ExcelGetColCount
From GECK
A function added by the SUP NVSE Plugin.
Contents
Description
Returns number of columns of specified sheet in Excel file.
Syntax
(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.