ExcelReadFloat
From GECK
A function added by the SUP NVSE Plugin.
Contents
Description
Reads numeric value from specified cell of specified Excel file.
Syntax
(fValue:float) ExcelReadFloat filepath:string WorksheetID:int Row:int Column:int
Or:
(fValue:float) XLSReadFloat filepath:string WorksheetID:int Row:int Column:int
Example
set fValue to ExcelReadFloat "aaExcelFile" 0 4 1
Will read numeric value from Cell[4;1] from Sheet with index 0 from "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.
