ExcelReadString

From GECK
Jump to: navigation, search


A function added by the SUP NVSE Plugin.

Description

Reads numeric value from specified cell of specified Excel file.

Syntax

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

Or:

(Value:string) XLSReadString filepath:string WorksheetID:int Row:int Column:int

Example

let s_Value := ExcelReadString "aaExcelFile" 0 4 1  

Will read string 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.

See Also