ExcelWriteFloat
From GECK
A function added by the SUP NVSE Plugin.
Contents
Description
Writes number(float\int) to specified Excel file.
Syntax
(iSuccess:int) ExcelWriteFloat filepath:string WorksheetID:int Row:int Column:int Value:float
Or:
(iSuccess:int) XLSWriteFloat filepath:string WorksheetID:int Row:int Column:int Value:float
Example
set iSuccess to ExcelWriteFloat "aaExcelFile" 0 0 0 10
Will write 10 to Cell[0;0] for Sheet with index of 0 of file "aaExcelFile.xls"
Notes
- if file doesn't exists - it will be created.
- if sheet in file doesn't exists - it will be created.
- File name is specified without extension.
- Cell row and column indexes start with 0.
- Sheet index starts with 0.
- if file can't be loaded(i.e. - it's open in Excel at the moment) - function returns -1.