ExcelWriteString
From GECK
A function added by the SUP NVSE Plugin.
Contents
Description
Writes string to specified Excel file.
Syntax
(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.