LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Excel: how to get last row value for two columns

Solved!
Go to solution
Highlighted

Hello there,

 

I am working on application where I need to make an excel file which has two columns, one for PASS UUTs and another for FAIL UUTs. For each result of test, i need to make an entry of unit's serial no. in respective columns.

I am using report generation tool-kit which has a function to get last row. However, it is returning value of 'bigger/longer' column. So, can i get last value for each particular column? 

 

Attached is the excel file for reference.

 

Thanks,

Manan

0 Kudos
Message 1 of 2
(281 Views)
Solution
Accepted by topic author Manan@MM
04-17-2019 06:56 AM

Hi Manan,

 

read the sheet until "last row", then search for empty cells (aka elements) in those 2 columns…

Best regards,
GerdW
CLAD expired, using 2009SP1 + LV2011SP1 + LV2017 (+LV2018 sometimes) on Win7+cRIO
Kudos are welcome Smiley Wink

0 Kudos
Message 2 of 2
(273 Views)