How do I read an excel file to display the worksheet on the web.

[sarunnio]

How do I read an excel file to display the worksheet on the web.

Can I make use of some excel automation to programmatically
manipulate the excel file via the web browser.

Thanks in advance.

What I 'd like to do is to create a link like shown below.

-Link1
-Link2
-Link3

If Link1 is clicked. the worksheet #1 of excel file must be shown on web browser.
Then Link2 is clicked. the worksheet #2 of excel file must be shown on web browser.

Could that be possible??

 

[Mark Rae]

How do I read an excel file to display the worksheet on the web.

Can I make use of some excel automation to programmatically
manipulate the excel file via the web browser.

Yes you can, though this approach is not recommended because of the massive
overhead it creates.

A much better solution, though not free, would be to use one of the 3rd
party utilities which can work with MS-Office files without having to
instantiate Office first.

I use this suite: http://www.aspose.com/

 

[Dennis Myrén]

You could use the OLE interface to read the workbook and it's sheets.
That way, you do not need to automate EXCEL and therefore you will not need
to have it installed on the machine from where this would run.
I wrote a component to do that and a web interface where you could load
workbook from an URL and view it's sheets.

 

[Mark Rae]

You could use the OLE interface to read the workbook and it's sheets.
That way, you do not need to automate EXCEL and therefore you will not
need to have it installed on the machine from where this would run.
I wrote a component to do that and a web interface where you could load
workbook from an URL and view it's sheets.

That's interesting... When you say "That way, you do not need to automate
EXCEL and therefore you will not need to have it installed on the machine
from where this would run", are you talking about the client or server?

 

[Dennis Myrén]

That would be the server, or actually neither server nor client, for that
matter.

The workbook is loaded and rendered to HTML.
So all the client will need is a browser.

 

[Mark Rae]

The workbook is loaded and rendered to HTML.

I'd be really interested in seeing how you do that without instantiating
Excel on the webserver...

 

[Dennis Myrén]

Hmm did i just say i use the OLE interface.
If you know what that is, you should have no problems understanding how i do
it.

But you seem not therefore you may download the sources and see for
yourself.
But if you want to start using it i would like to know that.
http://dennis.oslokb.no/OkbExcelReader_DEBUG.zip

 

[Mark Rae]

Hmm did i just say i use the OLE interface.

Yes you did, but I didn't realise you just meant OleDb - thanks for the link
anyway.

 

[Dennis Myrén]

A misunderstanding. Sorry.

Hope you like the little component.