javascript menu help

[arwatson2000]

I am creating a webpage and a need a series of drop-down menus.
I have the menu values in an excel file with 2 columns. comment and value

i want the meu to display:
comment 1 (value 1)
comment 2 (value 2)
comment 3 (value 3)

ie thryoidectomy (441030)
resection (45313)
biopsy (34333)

if you select biopsy the output is 3433, or if you select thyroidectomy the output is 441030

is there a way to write code so that the menu is created from a fiile?

thank you,
-a

[steven]

It is possible, however an excel spreadsheet file isn't the best method.

You can output your spreadsheet to CVS file (plain text representation of your spreadsheet), which you can then parse and use the data as you wish. You could also use an XML file, placing the data in an XML and parsing this to receive the data you need.

An XML file is simple and looks something like this:

<menu>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
</menu>
 

[arwatson2000]

thank you for your help.
i can get the data out of an excel file into any format, i am just not sure how to import this into javascript to appear as menus.

thank you,
-a

It is possible, however an excel spreadsheet file isn't the best method.

You can output your spreadsheet to CVS file (plain text representation of your spreadsheet), which you can then parse and use the data as you wish. You could also use an XML file, placing the data in an XML and parsing this to receive the data you need.

An XML file is simple and looks something like this:

<menu>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
  <item>
    <item_name>
    <item_value>
  </item>
 
</menu>