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.