Excel.Interfaces.TableLoadOptions interface

表示一个 Excel 表。Represents an Excel table.

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

属性

$all
autoFilter

表示表格的 AutoFilter 对象。Represents the AutoFilter object of the table.

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

columns

表示表中所有列的集合。Represents a collection of all the columns in the table.

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

highlightFirstColumn

指明第一列是否包含特殊格式。Indicates whether the first column contains special formatting.

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

highlightLastColumn

指明最后一列是否包含特殊格式。Indicates whether the last column contains special formatting.

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

id

返回用于唯一标识指定工作簿中表的值。即使表被重命名,标识符的值仍然相同。只读。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。Returns a numeric id.

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

name

表的名称。Name of the table.

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

rows

表示表中所有行的集合。Represents a collection of all the rows in the table.

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

showBandedColumns

指明列是否采用镶边格式来以不同的方式突出显示奇数列与偶数列,让表更易于阅读。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

指明行是否采用镶边格式来以不同的方式突出显示奇数行与偶数行,让表更易于阅读。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

指明是否在每个列标题的顶部显示筛选器按钮。仅当 table 中包含标题行时,才允许设定此设置。Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.

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

showHeaders

指示标头行是否可见。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

指示总计行是否可见。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

表示表的排序。Represents the sorting for the table.

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

style

表示表格样式的常量值。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

包含当前表格的工作表。The worksheet containing the current table.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoFilter

表示表格的 AutoFilter 对象。Represents the AutoFilter object of the table.

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

autoFilter?: Excel.Interfaces.AutoFilterLoadOptions;

属性值

columns

表示表中所有列的集合。Represents a collection of all the columns in the table.

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

columns?: Excel.Interfaces.TableColumnCollectionLoadOptions;

属性值

highlightFirstColumn

指明第一列是否包含特殊格式。Indicates whether the first column contains special formatting.

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

highlightFirstColumn?: boolean;

属性值

boolean

highlightLastColumn

指明最后一列是否包含特殊格式。Indicates whether the last column contains special formatting.

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

highlightLastColumn?: boolean;

属性值

boolean

id

返回用于唯一标识指定工作簿中表的值。即使表被重命名,标识符的值仍然相同。只读。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。Returns a numeric id.

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

legacyId?: boolean;

属性值

boolean

name

表的名称。Name of the table.

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

name?: boolean;

属性值

boolean

rows

表示表中所有行的集合。Represents a collection of all the rows in the table.

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

rows?: Excel.Interfaces.TableRowCollectionLoadOptions;

属性值

showBandedColumns

指明列是否采用镶边格式来以不同的方式突出显示奇数列与偶数列,让表更易于阅读。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

指明行是否采用镶边格式来以不同的方式突出显示奇数行与偶数行,让表更易于阅读。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

指明是否在每个列标题的顶部显示筛选器按钮。仅当 table 中包含标题行时,才允许设定此设置。Indicates whether the filter buttons are visible at the top of each column header. 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

指示标头行是否可见。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

指示总计行是否可见。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

表示表的排序。Represents the sorting for the table.

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

sort?: Excel.Interfaces.TableSortLoadOptions;

属性值

style

表示表格样式的常量值。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

包含当前表格的工作表。The worksheet containing the current table.

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

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值