ExcelGetCellValueType

A function added by the SUP NVSE Plugin.

Description

Returns value type of specified Cell in specified Excel file.

(iType:int) ExcelGetCellValueType filepath:string WorksheetID:int Row:int Column:int

Or:

(iType:int) XLSGetCellValueType filepath:string WorksheetID:int Row:int Column:int

set iType to ExcelGetCellValueType "aaExcelFile" 0 4 1

Will return type of Cell[4;1] from Sheet with index 0 from "aaExcelFile.xls"

0 - UNDEFINED;
1 - INT;
2 - Float;
3 - STRING;
4 - WSTRING;
5 - FORMULA;

if file doesn't exists or can't be loaded (i.e. - it's open in Excel at the moment) - function returns -1.