extract data from spreadsheet

need help with extracting data from a spreadsheet, perferably excel

[webfirst]

Hello everyone, this is my first post so excuse me if I'm doing something wrong or posting in the wrong place.

I need help with extracting data from a spreadsheet, such as an excel file and importing that data into a static html file.

I don't want to import the whole file into one page, I want specific information on specific lines and to import that data to the page/product it belongs to on an individual bases.

The main issue is that I have pricing information in an excel format that updates fairly often. There is around 10,000 products total, and updating is a nightmare.

I want to insert a line of code into each product page that will extract the relevant prices from the spreadsheet for that product. The order and line number is always the same for the spreadsheet and each line is specified by a product ID number.

I'm sure this is got to be simple, but I'm stumpped!

Any imput would be appreciated.

[jatar_k]

Welcome to WebmasterWorld webfirst,

well, if you save it as a csv file then you can walk through it and get the data you need. Though you would probably be better to store the info in a database on your site. You could then do a daily import and update all values in the db.

selecting relevant rows from a database would be faster, on average, then running through 10K lines in a file.

There is this thread from our Library [webmasterworld.com] that talks about the Basics of extracting data from CSV files [webmasterworld.com]

[webfirst]

Thanks for the input. This does seem to be a better plan then using such a large file with so many rows.