Excel.Interfaces.TableColumnCollectionLoadOptions interface

表示属于表的所有列的集合。Represents a collection of all the columns that are part of the table.

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

属性

$all
filter

对于集合中的每一项: 检索应用于列的筛选器。For EACH ITEM in the collection: Retrieve the filter applied to the column.

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

id

对于集合中的每一项: 返回标识表中的列的唯一键。For EACH ITEM in the collection: Returns a unique key that identifies the column within the table. 只读。Read-only.

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

index

对于集合中的每一项: 返回表的列集合中的列的索引号。For EACH ITEM in the collection: 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

对于集合中的每个项目: 代表表格列的名称。For EACH ITEM in the collection: 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

对于集合中的每一项: 代表指定区域的原始值。For EACH ITEM in the collection: 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

对于集合中的每一项: 检索应用于列的筛选器。For EACH ITEM in the collection: Retrieve the filter applied to the column.

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

filter?: Excel.Interfaces.FilterLoadOptions;

属性值

id

对于集合中的每一项: 返回标识表中的列的唯一键。For EACH ITEM in the collection: 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

对于集合中的每一项: 返回表的列集合中的列的索引号。For EACH ITEM in the collection: 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

对于集合中的每个项目: 代表表格列的名称。For EACH ITEM in the collection: 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

对于集合中的每一项: 代表指定区域的原始值。For EACH ITEM in the collection: 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