469,647 Members | 1,796 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Pulling data from an excel file

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
1 2566
<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.

Similar topics

1 post views Thread by david shapiro | last post: by
1 post views Thread by Usarian Skiff | last post: by
7 posts views Thread by danielbaars | last post: by
3 posts views Thread by lmefford | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.