Open excel workbook in browser

[Guest]

Hello,
I want to open an excel workbook, which is present in the server. I want
to open this excel in the browser using ASP.NET. May I know, how can I do
this?

Will the File.Open() command work here?

Please send me, any code snippet if present.

--With Regards,
Sheshadrinath

 

[Guest]

One way to achieve this is to display link to the file in your application
and user upon clicking that open directly in excel..

Check out the url which has a similar post related to yours.
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_21235305.html

 

[vinu]

Sheshadrinath

The very simplest way is to list the excel file as hyper link e.g.:
<a href="book.xls">Open</a>
And upon clicking the link web browser will display
a dialog box with Open Save and Cancel button, Click the open button

Alternatively you can use DataGrid and bind the excel sheet content to
DataGrid

See the following Post for more details...

http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/
http://support.microsoft.com/kb/306572/en-us


Vinu