excelGetCell
Syntax | excelGetCell(workbookFID, [worksheet_name], cell_addr_or_x_y) | Package | excel |
Alias |
| Pkg Usage | getCell(workbookFID, [worksheet_name], cell_addr_or_x_y) |
Description
Gets the string value from the specified cell.
Parameters
Parameter name | Type | Required | Description |
|---|---|---|---|
workbookFID | Integer | Yes | The file id of the open workbook. The file id is returned from running the excelOpenWorkbook() routine. |
worksheet_name | String | No | The name of the worksheet the cell is on. |
cell_addr_or_x_y | String | No | The cell address, like A1, or the cell coordinates like 2, 3. |
Return Type
String
Example
Get the values from cells in a workbook.
use "excel";
int fid = openWorkbook("snakes.xlsx");
string name = getCell(fid, "Venemous Snakes", "A2");
string species = getCell(fid, "Venemous Snakes", 1, 1);
runnerLog(name + " - " + species);
closeWorkbook(fid);Result: Mainland Tigersnake - Notechis Scutatus. Note that the row index used to get the species name is 1 even though the cell address would be B2. This is because the cell index starts at 0.
Click here to download the workbook used in this example.
See also
Need support? Create a request with our support team.
Copyright © 2005 - 2025 Appfire | All rights reserved.