Pulling data from an excel file

[bryanilton]

Hi guys, I hope that one of you gurus can help me out here.

Basically what I'd like to do is be able to price harddrives.

I'd like to have two drop-down boxes. One for the manufacturer and the
other for the harddrive capacity and then spit out a price. I don't
have access to any database or server side scripting so I think
javascript is the best solution but I could be completely off.

If anyone could help me out, I'd appreciate it a lot.

Thanks
Bryan

 

[Grant Wagner]

Hi guys, I hope that one of you gurus can help me out here.

Basically what I'd like to do is be able to price harddrives.

I'd like to have two drop-down boxes. One for the manufacturer and the
other for the harddrive capacity and then spit out a price. I don't
have access to any database or server side scripting so I think
javascript is the best solution but I could be completely off.

It's difficult for us to help you with a problem that is not clearly
defined.

Presumably you want to retrieve data from an Excel spreadsheet file and
display those contents in a <select> in a Web page?

If so, where does the Excel file reside? If it resides on the server
(the only place it could be for everyone accessing the Web page to have
access to it), you could try to use the XML HTTP Request object (or
AJAX) <url: http://jibbering.com/2002/4/httprequest.html /> to retreive
and parse it's contents. In that case, it would much much much better to
output the contents of the Excel file as comma- or tab-delimited or XML
to make retrieving and parsing the contents of the file easier.

Doing what I suggest would mean that the output of your Web page is
totally dependant on the user's Web browser supporting JavaScript,
having JavaScript enabled, and supporting AJAX (the XML HTTP Request
object). The comma- or tab-delimited or XML export of the Excel
spreadsheet would also have to reside on the same server as the Web page
requesting the information.