ExcelWriteFloat

From GECK
Jump to: navigation, search


A function added by the SUP NVSE Plugin.

Description

Writes number(float\int) to specified Excel file.

Syntax

[help]
(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.

See Also