Finding the End of File (EOF) in Labview

[unclebump]

Isn't there a function inside excel that can give you the last used row or the first empty row?? Could you put this value in your first row of excel data and use this value to control how many times labview loops.

[tbob]

Maybe you could write a custom EOF vi that uses the Read Excel vi inside a loop until the output is blank.  Then the offset would be the EOF marker.

[unclebump]

If you are using activex property nodes, try activesheet, then usedrange, then address.

[unclebump]

or activesheet, usedrange, rows, count to get the actual number of rows used.

[CAN Programmer]

Unclebump:

Thanks, it worked !