Excel.Interfaces.TableRowLoadOptions interface

Represents a row in a table.

Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

[ API set: ExcelApi 1.1 ]

Properties

$all
index

Returns the index number of the row within the rows collection of the table. Zero-indexed. Read-only.

[ API set: ExcelApi 1.1 ]

values

Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cells that contain an error will return the error string.

[ API set: ExcelApi 1.1 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

index

Returns the index number of the row within the rows collection of the table. Zero-indexed. Read-only.

[ API set: ExcelApi 1.1 ]

index?: boolean;

Property Value

boolean

values

Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cells that contain an error will return the error string.

[ API set: ExcelApi 1.1 ]

values?: boolean;

Property Value

boolean