LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Finding out the end of row in excel sheet

Iam trying to read the Excelvalues in to lab view. I have four columns with 'x' no of rows in the excel sheet. I want to create four arrays assiging each array to each column and store its values. Can any one pls help me how to find the end of row in the excel and store the column values in to arrays. Iam using the read_excel_values.llb vi from  NI website for my application. In this example it will extract the data from the excel sheet if we manually give start and end points. But what Iam looking for is the program should itself look for the end of the row and extract the data from the excel .

 

 

Thank you,

 

Shanth.

0 Kudos
Message 1 of 3
(2,690 Views)

Hi Shanth,

see this link:

http://forums.ni.com/ni/board/message?board.id=170&message.id=333106&query.id=33090#M333106

 

If you know the number of rows, then you can read the entire column at ones.

 

Mike

0 Kudos
Message 2 of 3
(2,681 Views)

Mike,

 

         Can you pls attach that vi. I think this is what something Iam looking for.

 

Thank you,

Shanth.

0 Kudos
Message 3 of 3
(2,672 Views)