ExcelGetRowCount
From GECK
A function added by the SUP NVSE Plugin.
Contents
Description
Returns number of rows of specified sheet in Excel file.
Syntax
(iCount:int) ExcelGetRowCount filepath:string WorksheetID:int
Or:
(iCount:int) XLSGetRowCount filepath:string WorksheetID:int
Example
set iCount to ExcelGetRowCount "aaExcelFile" 0
Will return number of rows in Worksheet with index 0 of "aaExcelFile.xls"
Notes
- if file doesn't exists or can't be loaded (i.e. - it's open in Excel at the moment) - function returns -1.
