ExcelGetWorkSheetCount

A function added by the SUP NVSE Plugin.

Description

Returns number of sheets in Excel file.

Syntax

[help]

(iCount:int) ExcelGetWorkSheetCount filepath:string

Example

set iCount to ExcelGetWorkSheetCount "aaExcelFile"

Will return number of sheets in "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.

See Also

• ExcelWriteFloat
• ExcelWriteString
• ExcelReadFloat
• ExcelReadString
• ExcelGetRowCount
• ExcelGetColCount
• ExcelSetSheetName
• ExcelGetCellValueType
• ExcelEraseCell
• ExcelEraseSheet