Excel Worksheet Range Import

[id]

Hello,

I am looking to append several excel worksheet files that are separate files by reading them into a 2d array and appending records for further data manipulation.

I have seen examples on how to do this with the array spreadsheet to string vi  but it requires that the excel file already be saved in a tab delimited text format, not the standard xls.

How do I open a file, select a range from A1 to the end of usable data and then read it into a Labview Array?  Any help would be beneficial here...

MJM 

[Ray.R]

Hi MJM,

Maybe I misunderstood your question..  Are you trying to read from an Excel spreadsheet to a LV VI?  This is the LabWindows-CVI forum.. 

If it is a LV question, then have a look at this thread:  http://forums.ni.com/ni/board/message?board.id=170&message.id=1892

Basically, reading or writing to / from Excel uses Active-X and not the Read From Spreadsheet vi's.. 

If it is a LabWindows-CVI coding question, then please provide more details.

RayR