ExcelWriteString

From GECK
Jump to: navigation, search


A function added by the SUP NVSE Plugin.

Description

Writes string to specified Excel file.

Syntax

[help]
(iSuccess:int) ExcelWriteString filepath:string WorksheetID:int Row:int Column:int Value:string 

Or:

(iSuccess:int) XLSWriteString filepath:string WorksheetID:int Row:int Column:int Value:string

Example

set iSuccess to ExcelWriteString "aaExcelFile" 0 0 0 "MyText"  

Will write "MyText" 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