Excel.Interfaces.TableUpdateData interface

一个用于更新 Table 对象上的数据的接口, 可用于 "table. set (An interface for updating data on the Table object, for use in "table.set({ ... })".

属性

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 ]

name

表的名称。Name of 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 ]

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 ]

属性详细信息

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

name

表的名称。Name of the table.

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

name?: string;

属性值

string

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

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?: string;

属性值

string