Using Excel in HTML
Hi Webdeveloper users,
To get the price from the site, at first i temporarily used if statements to get price, but its really really long!! and editing prices are a pain! I want to be able to have a table of price on xls and be able to retrieve the price based on the customer's input. Eg,
the excel would have the following as
row; Lhr, Lgw, Stn
Column; HA1, HA2, HA3
and in between these would be prices. The passengers would select airport from select type menu and another for postcodes. On the next page, i should have page with the price for the selected locations. I have no idea on how about i would be doing this, i hope you will help me..
I just understanding your situation but i m not sure that.. can you make a screen shots and put it here so we can help you
An alternative is to use PHP libraries, such as PHPExcel and PHPExcelReader. Even though you said you have no knowledge of PHP, these libraries are written for you, so it's just a matter of specifying the file and using their functions (and they come with examples and documentation).
The last alternative is to make your life a bit easier in the long run and use a database. If it's not too large right now, you can migrate the information.
If you really want to use VBA for this, you can by converting everything to a .CSV and writing code to read it or use a library for it. Again, this depends exactly what you want the result to look like, its functionality, any other features, etc... .
As others have said, CSVs might be an easier way to go other than Excel files. Could you not use a database in this situation? (it sounds like this would be ideal for looking up results like you would want)