f$Excel get cell
f$Excel get cell
Read in the value of a cell in the current sheet. The cell is accessed via the line and column numbers. Advice: the address of a definite name can be retrieved with f$Excel readname.
Syntax: | Status = f$Excel('Cell', 'get', Row , Column , ParameterName ) | ||
| Argument | Type | Meaning |
| 'Cell' | String | Keyword |
| 'get' | String | Keyword |
| Line | Integer | Line number |
| Column | Integer | Column number |
| ParameterName | String | Name of the ePOS parameter on which the value is to be written. If the cell number is numeric, an ePOS parameter of integer or decimal type can also be used. |
Result: | Integer | 0: command executed successfully | |
Example: | Status = f$Excel('Workbook','open','c:\\temp\\test2.xls') | ||