Combo box item source from excel

[Nandha]

Hi all

I've been wondering about this one. I have lots of values to choose, say 100 values . And i want it to appear in the combo box, it would be very painful if i have to put the data into the "edit item" function from the right click of the combo box. Since i kept the values in excel, is there any way to edit the items in the combo box (or maybe listbox) using automated method, export??

Thanks

[MikeS81]

Hi Nandha,

you can use ActiveX to read your data from Excel. You can write values into a combobox with the property "strings".

Mike

[Nandha]

Can't really sure of how to use activeX, can u help me.

My case is actually simple, i don't need to update the combo box the whole time. Just need to input the items (which consist of 100 values). The file can be anything (text) excel, or tabbed text. Do you have any example on using activeX for this case?

Thanks

[MikeS81]

Hi Nandha,

see this link for more information about ActiveX. If you have a csv file, then you can use the "Read from Spreadsheet File" function.

Mike

[Nandha]

Hi Mike 

Okay, let say i  can take all the items (and values) from .csv file (using read file or read spreadsheet), Let say I can make an array out of it, then what?

In the combo box property node, there is no option for "item" . There is though "value" property but it is also using string as input, not array.

please help me

thanks

[mikeporter · Accepted solution]

For a combo box, what you're looking for is the Strings[] property.

Mike...

[MikeS81]

---

MikeS81 wrote:

Hi Nandha,

you can use ActiveX to read your data from Excel. You can write values into a combobox with the property "strings".

Mike

---

Hi Nandha,

i thought this helps. 

Mike

[Nandha]

Sorry mike,

Completely miss that one, and more over I thought that the one that i marked as solution was You (almost same "mike--").

Once again sorry. I'll give kudos to you then.

[SZArjun]

How do you read data off a combo box?

Arjun

[Nandha]

would you elaborate your question more.

because to read a combo box data just simply connect the wire from the combo box into any variable/controller/indicator that you want.

To edit the item from a combo box, simply right click the combo box either from front panel and choose 'edit items' or from block diagram and chose 'properties' and go to 'edit items' tab. The value that will be displayed in the front panel is the value from the 1st column and the value that will sent through the wire is the value from 2nd column of the 'edit items' table.