Populate input array with spreadsheet values

[Joe_V]

Is it possible to populate an input array with values from a text or spreadsheet file? If so, how is it done?

[J.DECHET]

In the 'String' palette, you can find the function : Spreadsheet string to array

[Joe_V]

To be more exact, I need to populate an array control with values from a file.

[GerdW]

Hi Joseph,

"to be more exact":

load the [text] file and use "spreadsheet string to array" (older LV versions) or use "read spreadsheet file" (LV8+)

[J.DECHET]

If there are several types in your file unit element and you want to use 'Spreadsheet string to array', the easiest way is to reformat your data as 2D String array and to work after line by line (or column). For example,

[Joe_V]

An array control has an output but no input so "Read from spreadsheet file" will not work. When I use a property node (Array Element.Value) to populate the array control it fails and returns the error message "LabVIEW:  The data type of the variant is not compatible with the data type wired to the type input."

[GerdW]

Hi Joseph,

what about using a local of the array control? Show code...

[Joe_V · Accepted solution]

Many thanks to GerdW and all who replied. Populating an array control using a local variable with "Read from spreadsheet file" as it's input works perfectly.

[GerdW]

Hi Joseph,

I don't want to be picky, but marking your answer as solution doesn't feel right

[Joe_V]

Hi Gerd,

Please forgive my mistake. You deserve credit for the solution to my post.  Your pickyness has improved my forum etiquette.

Thanks Again,

Joe