Excel.Interfaces.TableRowLoadOptions interface

表示表中的行。Represents a row in a table.

请注意, 与在添加新行/列之前的区域或列不同, TableRow 对象表示表行的物理位置, 而不是数据。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 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性

$all
index

返回表的行集合内行的索引编号。Returns the index number of the row within the rows collection of the table. 从零开始编制索引。Zero-indexed. 只读。Read-only.

[API 集: ExcelApi 1.1][ 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 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

index

返回表的行集合内行的索引编号。Returns the index number of the row within the rows collection of the table. 从零开始编制索引。Zero-indexed. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

index?: boolean;

属性值

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 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

values?: boolean;

属性值

boolean