Moving excel data into HTML

[alexanderdring]

Hi everyone,

I was wondering if anyone knew how to reference data from excel spreadsheets and display them in HTML? I'd like to create a form where someone can type in, say, a PRODUCT NUMBER like this:

PRODUCT NUMBER: 02316891968

TYPE: -------------

POWER SUPPLY: -----------

etc.

and have all of the information related to that product (TYPE, POWER SUPPLY) appear in boxes on another page like this:

PRODUCT NUMBER: 02316891968

TYPE: COMPUTER

POWER SUPPLY: 220v

iT would also be great if it could happen the other way around, so if they type in POWER SUPPLY, the closest PRODUCT NUMBER to that figure would appear in the same way. I hope that's clear. At present, I intend to put it together off-line as a CD-based technical source. This would seem to suggest option one and hopefully be a little easier compared to putting it on the web, which is a long way in the future of this project!

Thanks again.

Alex D.

 

[simonchristieis]

you can populate the table with data from excel using data binding - be careful which browsers support this though, however if you want to search the data - then you dont really want to load it all into the page, you can use excel as a database and use asp to query the data - or populate the table and use some javascript to display the data required.

 

[alexanderdring]

Only trouble is, I've never used asp before and I could do with a bit of guidance on javascript too! If you could suggest the code needed to reference one piece of data in excel and import it into a HTML box, I should be able to fill in a lot of the pieces from there on.

Thanks for the reply.

Alex D.

 

[simonchristieis]

try sommat like this - for more details goto msdn.microsoft.com and look up ActiveXObject



function exceldemo()
{
var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application"
ExcelSheet = new ActiveXObject("Excel.Sheet"
ExcelSheet.Application.Visible = true;
if(ExcelSheet.ActiveSheet.Cells(1,1).Value == "whatever&quot{
alert(ExcelSheet.ActiveSheet.Cells(1,1).Value)
}

ExcelSheet.Application.Quit();
}