Excel Number of Rows

[James@Motorola]

I am opening an excel file using CVI 7.1, I need to know how to find the number of rows with non-empty cells within the speedsheet.

Using ExcelRpt_GetWorksheetAttribute (ExcelWorksheetHandle, ER_WS_ATTR_USED_RANGE, dataRange)
doesn't work properly as if the hight of a row has been adjusted from default or if there is any kind of formating on a row, then that row is counted even if its cells are empty.
I only want to count rows where the cells have data entered into them?
Any ideas on how I can do this?

Thanks
James

[Steven Bird]

James, Bring all the cells in and test the data within each element of the range thats probabley the easiest way around this issue.

Kind Regards


Steven Bird
Applications Engineer
National Instruments