Accessing a range of data from an Excel file

[jackskellington321]

I want to take a set of numbers from an excell file and put them into an array. Is there any way to use the "Excel Get Data.vi" as an array data type to get these values? I can't find any information on the syntax to use the VI's paramater name to specify a range of cells within the excel file that I want to use.

[Grampa_of_Oliva_n_Eden]

QUOTE(jackskellington321 @ Jun 14 2007, 02:03 PM)

I want to take a set of numbers from an excell file and put them into an array. Is there any way to use the "Excel Get Data.vi" as an array data type to get these values? I can't find any information on the syntax to use the VI's paramater name to specify a range of cells within the excel file that I want to use.

JHoskins (and others) has been collecting LV with Excel links in this thread on the NI site.

http://forums.ni.com/ni/board/message?board.id=BreakPoint&message.id=2391&jump=true' target="_blank">http://forums.ni.com/ni/board/message?boar...1&jump=true

Ben

[i2dx]

QUOTE(jackskellington321 @ Jun 14 2007, 08:03 PM)

I want to take a set of numbers from an excell file and put them into an array. Is there any way to use the "Excel Get Data.vi" as an array data type to get these values? I can't find any information on the syntax to use the VI's paramater name to specify a range of cells within the excel file that I want to use.

you have to specify the range with the "range" property and get the reference to that range:

http://forums.lavag.org/index.php?act=attach&type=post&id=6104''>http://forums.lavag.org/index.php?act=attach&type=post&id=6104'>http://forums.lavag.org/index.php?act=attach&type=post&id=6104

what makes that difficlut compared to reading a single cell (as shown in the screenshot) is, that you have to be sure, that all data in that cells have the same datatype, otherwise you'll run into conversion problems (because you get the data as variant ...)