General discussion

Locked

Excel to web

By GuruOfDos ·
I have an Excel spreadsheet (40 cols x 72 rows) containing a table of products. I want to create several web-pages where I have various images and lines of text. Every so often on a page, there is a piece of text which I want to update dynamically from the spreadsheet.

For example, several columns on the spreadsheet refer to product prices. If I change the prices in the spreadsheet,then upload the spreadsheet to my webserver, I want viewed pages to display the updated prices, i.e. by loading data from the particular cell. Or to put it another way, I need to embed one item from a data file (excel, csv, text or whatever) into a page, and call up that data every time the page is loaded. Changing the item in the data file causes the page to update next time it is requested.

Any clues? My webserver (basically HTTP only)doesn't support CGI (well...it COULD handle VBScript, Javascript or Perl at a pinch, and I have a book on Perl but it doesn't cover Excel)
or scripting, other then for sendmail or form processing. I 'could' use client-side scripting (javascript) but I haven't seen any articles on using javascript to extract one cell from an Excel spreadsheet.

Any alternatives greatly appreciated.

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Srikrishna In reply to Excel to web

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..

Collapse -

by Srikrishna In reply to

sorry the url abv is not working..the corrected one is as follows

http://support.microsoft.com/default.aspx?scid=kb;en-us;195951

Collapse -

by Srikrishna In reply to

:) sorry guys..silly mistakes..its KB 195951..u can search for the article.

Collapse -

by GuruOfDos In reply to

Related to publishing spreadsheets, not importing data from ONE cell!

Collapse -

by DKlippert In reply to Excel to web

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

Collapse -

by GuruOfDos In reply to

Putting MS Office extensions on the server is not allowed! Perhaps converting the Excel data to a Javascript array is the answer? Excel just 'happens' to be the format I have my data in right now, but at the end of the day, it's just a 40 x 72
'grid' with a value in each location.

Collapse -

by MadestroITSolutions In reply to Excel to web

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!

Collapse -

by GuruOfDos In reply to

It is an http only server...no cgi, no scripts, no perl, no asp!

Collapse -

by GuruOfDos In reply to

It is an http only server...no cgi, no scripts, no perl, no asp!

Collapse -

by markguer In reply to Excel to web

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.

Back to Web Development Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums