Excel.Interfaces.TableCollectionLoadOptions interface

表示属于工作簿或工作表(具有取决于限定到的范围)的所有表的集合。Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

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

属性

$all
autoFilter

对于集合中的每一项: 代表表的自动筛选对象。For EACH ITEM in the collection: Represents the AutoFilter object of the table.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

columns

对于集合中的每一项: 代表表中所有列的集合。For EACH ITEM in the collection: Represents a collection of all the columns in the table.

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

highlightFirstColumn

对于集合中的每一项: 指示第一列是否包含特殊格式。For EACH ITEM in the collection: Indicates whether the first column contains special formatting.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

highlightLastColumn

对于集合中的每一项: 指示最后一列是否包含特殊格式。For EACH ITEM in the collection: Indicates whether the last column contains special formatting.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

id

对于集合中的每一项: 返回一个值, 该值唯一地标识给定工作簿中的表。For EACH ITEM in the collection: Returns a value that uniquely identifies the table in a given workbook. 即使表被重命名,标识符的值仍然相同。The value of the identifier remains the same even when the table is renamed. 只读。Read-only.

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

legacyId

对于集合中的每一项: 返回一个数字 id。For EACH ITEM in the collection: Returns a numeric id.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

name

对于集合中的每一项: 表的名称。For EACH ITEM in the collection: Name of the table.

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

rows

对于集合中的每一项: 代表表中所有行的集合。For EACH ITEM in the collection: Represents a collection of all the rows in the table.

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

showBandedColumns

对于集合中的每一项: 指示列是否显示条带格式, 其中奇数列以不同的方式突出显示, 而不是为了使表更易于阅读。For EACH ITEM in the collection: Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showBandedRows

对于集合中的每一项: 指示行是否显示条带格式, 其中奇数行以不同的方式突出显示, 即使是偶数行, 也可以使表更易于阅读。For EACH ITEM in the collection: Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showFilterButton

对于集合中的每一项: 指示筛选按钮是否显示在每个列标头的顶部。For EACH ITEM in the collection: Indicates whether the filter buttons are visible at the top of each column header. 仅当 table 中包含标题行时,才允许设定此设置。Setting this is only allowed if the table contains a header row.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showHeaders

对于集合中的每一项: 指示标题行是否可见。For EACH ITEM in the collection: Indicates whether the header row is visible or not. 该值可以设置为显示或删除标头行。This value can be set to show or remove the header row.

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

showTotals

对于集合中的每一项: 指示汇总行是否可见。For EACH ITEM in the collection: Indicates whether the total row is visible or not. 该值可以设置为显示或删除总计行。This value can be set to show or remove the total row.

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

sort

对于集合中的每一项: 表示对表的排序。For EACH ITEM in the collection: Represents the sorting for the table.

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

style

对于集合中的每一项: 表示表样式的常量值。For EACH ITEM in the collection: Constant value that represents the Table style. 可能的值为: "TableStyleLight1" 到 "TableStyleLight21"、"TableStyleMedium1" 通过 "TableStyleMedium28"、"TableStyleStyleDark1" 到 "TableStyleStyleDark11"。Possible values are: "TableStyleLight1" through "TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleStyleDark1" through "TableStyleStyleDark11". 还可以指定工作簿中显示的用户定义的自定义样式。A custom user-defined style present in the workbook can also be specified.

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

worksheet

对于集合中的每一项: 包含当前表的工作表。For EACH ITEM in the collection: The worksheet containing the current table.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoFilter

对于集合中的每一项: 代表表的自动筛选对象。For EACH ITEM in the collection: Represents the AutoFilter object of the table.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

autoFilter?: Excel.Interfaces.AutoFilterLoadOptions;

属性值

columns

对于集合中的每一项: 代表表中所有列的集合。For EACH ITEM in the collection: Represents a collection of all the columns in the table.

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

columns?: Excel.Interfaces.TableColumnCollectionLoadOptions;

属性值

highlightFirstColumn

对于集合中的每一项: 指示第一列是否包含特殊格式。For EACH ITEM in the collection: Indicates whether the first column contains special formatting.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

highlightFirstColumn?: boolean;

属性值

boolean

highlightLastColumn

对于集合中的每一项: 指示最后一列是否包含特殊格式。For EACH ITEM in the collection: Indicates whether the last column contains special formatting.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

highlightLastColumn?: boolean;

属性值

boolean

id

对于集合中的每一项: 返回一个值, 该值唯一地标识给定工作簿中的表。For EACH ITEM in the collection: Returns a value that uniquely identifies the table in a given workbook. 即使表被重命名,标识符的值仍然相同。The value of the identifier remains the same even when the table is renamed. 只读。Read-only.

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

id?: boolean;

属性值

boolean

legacyId

对于集合中的每一项: 返回一个数字 id。For EACH ITEM in the collection: Returns a numeric id.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

legacyId?: boolean;

属性值

boolean

name

对于集合中的每一项: 表的名称。For EACH ITEM in the collection: Name of the table.

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

name?: boolean;

属性值

boolean

rows

对于集合中的每一项: 代表表中所有行的集合。For EACH ITEM in the collection: Represents a collection of all the rows in the table.

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

rows?: Excel.Interfaces.TableRowCollectionLoadOptions;

属性值

showBandedColumns

对于集合中的每一项: 指示列是否显示条带格式, 其中奇数列以不同的方式突出显示, 而不是为了使表更易于阅读。For EACH ITEM in the collection: Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showBandedColumns?: boolean;

属性值

boolean

showBandedRows

对于集合中的每一项: 指示行是否显示条带格式, 其中奇数行以不同的方式突出显示, 即使是偶数行, 也可以使表更易于阅读。For EACH ITEM in the collection: Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showBandedRows?: boolean;

属性值

boolean

showFilterButton

对于集合中的每一项: 指示筛选按钮是否显示在每个列标头的顶部。For EACH ITEM in the collection: Indicates whether the filter buttons are visible at the top of each column header. 仅当 table 中包含标题行时,才允许设定此设置。Setting this is only allowed if the table contains a header row.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

showFilterButton?: boolean;

属性值

boolean

showHeaders

对于集合中的每一项: 指示标题行是否可见。For EACH ITEM in the collection: Indicates whether the header row is visible or not. 该值可以设置为显示或删除标头行。This value can be set to show or remove the header row.

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

showHeaders?: boolean;

属性值

boolean

showTotals

对于集合中的每一项: 指示汇总行是否可见。For EACH ITEM in the collection: Indicates whether the total row is visible or not. 该值可以设置为显示或删除总计行。This value can be set to show or remove the total row.

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

showTotals?: boolean;

属性值

boolean

sort

对于集合中的每一项: 表示对表的排序。For EACH ITEM in the collection: Represents the sorting for the table.

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

sort?: Excel.Interfaces.TableSortLoadOptions;

属性值

style

对于集合中的每一项: 表示表样式的常量值。For EACH ITEM in the collection: Constant value that represents the Table style. 可能的值为: "TableStyleLight1" 到 "TableStyleLight21"、"TableStyleMedium1" 通过 "TableStyleMedium28"、"TableStyleStyleDark1" 到 "TableStyleStyleDark11"。Possible values are: "TableStyleLight1" through "TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleStyleDark1" through "TableStyleStyleDark11". 还可以指定工作簿中显示的用户定义的自定义样式。A custom user-defined style present in the workbook can also be specified.

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

style?: boolean;

属性值

boolean

worksheet

对于集合中的每一项: 包含当前表的工作表。For EACH ITEM in the collection: The worksheet containing the current table.

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

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值