HTML and Excel

[Taera]

i need help there, does anyone know how to incorporate information from excel files into HTML files? what im looking for is putting specific cells in specific .xls file into an HTML page. anyone?

[Fyron]

Maybe there is an export option that will help?

What happened to going to sleep?

[Taera]

i didnt say i was going to sleep, i said good night
im studying for test fyron

"export" - i want the HTML to refer directly to the Excel so i only need to change one file - the .xls - for changes to take effects in numerous places. i want to use the .xls as a database for numbers untill i learn proper language such as php.

(interesting, i joined the same time fyron did... but he has 6 times my Posts)

[ June 02, 2003, 08:25: Message edited by: Taera ]

[Fyron]

You can convert it to a database type file and then write a PERL, PHP, etc. script to get the values out of it. I don't think there is a way to do it with just HTML. If there is, I haven't heard of it.

Some way to study for a test, posting on shrapnel.

[Jack Simth]

There is almost certainly a way to do it with VBscript, but that would require learning VBscript. Ideally, you do want to learn PHP or some such. Short term, you could theoretically build all the web pages that use the numbers as Excel spreadsheets, save the .xls Version, and use Excel's Save As function to have it generate HTML. You then have to re-post all of the HTML files every time, but you only need to change things in one place. Mind you, Microsoft products generate bad HTML and script, but it should work.

[Taera]

yes fyron i know i need to learn php and i can do it via php. and yes im studying, just the page was open and the thought ran through my head... duh

jack - well yes, i guess thats the only way after all... i just thought i've seen somewhere a mentioning of using .xls spreadsheets as a simplified database accessible from other sources. bad luck, i guess.