By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,865 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,865 IT Pros & Developers. It's quick & easy.

Pulling data from an excel file

P: n/a
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

Jul 26 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<br********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
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.

--
Grant Wagner <gw*****@agricoreunited.com>
comp.lang.javascript FAQ - http://jibbering.com/faq
Jul 27 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.