PDA

View Full Version : Searching HTML made from Excel


thatboynii
10-07-2010, 10:27 AM
I have a client who wants to put their stock catalog on-line - although they don't plan on selling the items online.

They currently have an in-house system which stores their stock - which can export the database to excel, if they need to send an updated stock list to a client.

At present this excel spreadsheet has been converted into an HTML document and sits on the page within an iframe.

However they would like people to be able to search this document - although they are not happy with telling people to use the browser ctrl-f functionality -

Is there another way around this?

Although Excel is a drag to work with - in terms of going forward anything else for the client would create a duplication of work for them.

Corrosive
10-07-2010, 10:52 AM
You may be able to import the excel into a MySQL database and then create a search function using PHP. CSV (comma separated values) may be the best format for conversion.

thatboynii
10-07-2010, 11:06 AM
Thanks for your repsonse Corrosive, I will look into this. Although this would mean that whenever they update their stock list, I would then need to update the database - or do you think it would be possible to create something where they could upload the spreadsheet or csv file, and it would re-populate the table?

Corrosive
10-07-2010, 11:17 AM
Thanks for your repsonse Corrosive, I will look into this. Although this would mean that whenever they update their stock list, I would then need to update the database - or do you think it would be possible to create something where they could upload the spreadsheet or csv file, and it would re-populate the table?

Yeah, that's what I was thinking which is why I suggested CSV as a format.