Accessing Cells
To access a particular cell you need to access the relevant row and use the field name which is the value in the first row of the relevant column.
Example
This example demonstrates referencing the first column (with name Fourth
) on row 4:
1: 2: 3: 4: 5: 6: 7: 8: 9: |
|
And the variable test
has the following value:
|
Cells can be accessed dynamically using the zero-based column index or case-sensitive header name:
1: 2: |
|
The variables testByIndex
and testByHeader
have the respective values:
|
|
Accessing cell values by index or string header sacrifices type safety; the result signature is obj
.