07-08-2009 10:38 AM
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.
07-08-2009 11:09 AM
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
07-08-2009 11:31 AM
Mike,
Can you pls attach that vi. I think this is what something Iam looking for.
Thank you,
Shanth.