Excel pull down menu / hypertext to Grasshopper

Replies to This Discussion

Permalink Reply by Jesus Galvez on March 4, 2013 at 2:07pm

Correct me if I'm wrong, but a pull-down menus in Excel are simply a cell formatted as a pull-down menu which references a list of cells. It's the Data > Data Tools > Data Validation tool.

If you use the [Excel Reader] component from Lunchbox you can translate cells from Excel as List in GH. However if you read the cell with the pull-down menu, in GH you won't get a pull-down menu, you'll only get the item which is in the pull-down menu of Excel when you toggle the component. You can use the list that the [Excel Reader] component gives with the [Launch Application], also from Lauchbox, to toggle a hyperlink. 

To avoid the inconvenience of not having the pull down menu in GH, the best way is to use the [Excel Reader] component read the list of cells instead of the pull-down menu, and once you have the whole list in Excel, pick the item you want and input it in the [Launch Application] component. 

In the files I uploaded, I don't know if the path of the excel file matters, so I just put it in C:\. It has to be opened for the GH file to work 

Attachments:

• Excel hyperlink.gh, 3 KB
• Book1.xlsx, 9 KB

Permalink Reply by Landscape on March 4, 2013 at 2:50pm

Thank U very much Jesus!! ;-)