Web Development

Hi,
You can try this..u can find more info at the following URL.
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q195/9/51.asp&NoWebContent=1
here u'll get the excel header also.u can turn off the header string by adding hdr=NO to the connection string..

Here's some information from John Walkenbach:
http://tinyurl.com/qord
___
You need to have the MS Office Server Extensions loaded on the server and
then, when you save your Excel File as HTML, click "Interactive"
___
HOW TO: Use the AutoRepublish Feature in Excel 2002 289262

http://tinyurl.com/qopx

"Turn On AutoRepublish
To turn on the AutoRepublish feature, follow these steps:
Start Excel, and then open or create the workbook that you want to save as a Web page.
Click Save as Web Page.
Click Publish.
In the File name box, type the path and file name that you want.
Click to select the AutoRepublish every time this workbook is saved check box, and then click Publish.

___
Here's a commercial solution:
Microsoft Excel on the Web (www) HTML, Java, JavaScript ASP, ASP.net, J2SE / J2EE
Put Microsoft Excel on the internet or company intranet

http://tinyurl.com/qoq3

Well, what you are talking about my friend is done with databases. But then again you are probably asking this question here because you don't have the resources to use a database. Anyways, assuming you don't, I would do one of the following:

1) I would save the Excel file as text (Comma delimmited) and then I would read it when the page loads, and produce the output dinamically. Now, how do you read it is the question. It really depends on what kind of server you have. If you have a Windows Host, then chances are they must likely support ASP, so it would be super easy to do. If it is a UNIX Server, then you will have to do it with either Perl or VBScript/Javascript.

2) You can instantiate an excel object, and use it to read the datasheet and produce the desired output dinamically..... The problem with this approach is that it relies on Office components being installed in the server, which in your case is highly unlikely, so go with approach #1.

If you have any questions, please DO NOT REJECT MY ANSWER, drop me a line at juanja01@optonline.net, and I will help you out.

Good Luck!

Guru,

Save your Excel sheet as a CSV file within Excel.
Then use Active Server Page code utilizing the FSO (File System Object) to open the CSV file, loop to the "cell" where your value is and display it on your web page. Here is a link which will give you working examples of asp programming using the FSO of ASP.

http://www.15seconds.com/Issue/000816.htm

I have some basic code which will outline the reading and writing of a csv file via asp. Give me a shout if you want me to email them to you.