Excel.Interfaces.TableColumnLoadOptions interface

代表表格中的一列。Represents a column in a table.

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

属性

$all
filter

检索应用于列的筛选器。Retrieve the filter applied to the column.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

id

返回标识表内的列的唯一键。Returns a unique key that identifies the column within the table. 只读。Read-only.

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

index

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

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

name

表示表列的名称。Represents the name of the table column.

[API 集: ExcelApi 1.1 用于获取名称; 1.4 用于设置名称。[ API set: ExcelApi 1.1 for getting the name; 1.4 for setting it. ]

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

filter

检索应用于列的筛选器。Retrieve the filter applied to the column.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

filter?: Excel.Interfaces.FilterLoadOptions;

属性值

id

返回标识表内的列的唯一键。Returns a unique key that identifies the column within the table. 只读。Read-only.

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

id?: boolean;

属性值

boolean

index

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

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

index?: boolean;

属性值

boolean

name

表示表列的名称。Represents the name of the table column.

[API 集: ExcelApi 1.1 用于获取名称; 1.4 用于设置名称。[ API set: ExcelApi 1.1 for getting the name; 1.4 for setting it. ]

name?: 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