ExcelGetColCount

From GECK
Jump to: navigation, search


A function added by the SUP NVSE Plugin.

Description

Returns number of columns of specified sheet in Excel file.

Syntax

[help]
(iCount:int) ExcelGetColCount filepath:string WorksheetID:int 

Or:

(iCount:int) XLSGetColCount filepath:string WorksheetID:int

Example

set iCount to ExcelGetColCount "aaExcelFile" 0

Will return number of columns 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.

See Also