View Excel in a web page

[kanejone]

Hi guys,
I have two question. I was wondering if anyone knows how to view and existing excel spreadsheet through a web page. And secondly, how do I update this using and ASP form.
Thanks
JK

[jdavison]

I know in ie all you have to do is download the document if you have excel installed on the client and it will run excel in the browser. As far as mimicking an excel document through asp, thats a bit messy from my experience. It may be easier to run some vba code in that excel document and put the inforamtion in an xml document and then run the xml parser through asp and put the page together that way. Hopefully somebody else here has a better background and may have a simpler answer.

[Clunietp]

I believe Excel 2000 will save the doc as a mix of HTML/XML so it's ready to be viewed by IE 5+ when you choose "Save as web page..."

[jdavison]

well that makes it a hell of alot easier then. We had to write out the vba code to get it to build the xml in 97

[Clunietp]

That would piss me off if I did all that, got it working, then MS gets it automated for me.....

the quote "experience is what you get when you didn't get what you really wanted" comes to mind :)

[jdavison]

doesnt it:) I had a friend who spent a month in a half working on this problem with sql server and some dts stuff with excell and email. called ms and did a bunch of research for it...he finally gets it to work the way they wanted and no more that 2 days later ms releases a patch for sql server fixing it and he could have done it all in under an hour. Now that would piss you off:) Hes still mad about that and that was over a year ago.

[nybble]

you can post data into a spreadsheet the same way you would do with an excel database... you just need to select the excel driver, the connection string would be something like this... (may need some tweaking).


"Provider=MSDASQL;DRIVER={Microsoft Excel Driver (*.xls)};DBQ=c:\yourexcelsheet.xls;UID=sa;PWD=;"

[kanejone]

Thanks a lot