Excel.Interfaces.TableData interface

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "table.toJSON()".

属性

autoFilter

表示表格的 AutoFilter 对象。Represents the AutoFilter object of the table. 只读。Read-Only.

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

columns

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

[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. 只读。Read-only.

[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. 只读。Read-only.

[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 ]

属性详细信息

autoFilter

表示表格的 AutoFilter 对象。Represents the AutoFilter object of the table. 只读。Read-Only.

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

autoFilter?: Excel.Interfaces.AutoFilterData;

属性值

columns

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

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

columns?: Excel.Interfaces.TableColumnData[];

属性值

Excel.Interfaces.TableColumnData[]

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

属性值

string

legacyId

返回一个数字 id。Returns a numeric id.

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

legacyId?: string;

属性值

string

name

表的名称。Name of the table.

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

name?: string;

属性值

string

rows

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

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

rows?: Excel.Interfaces.TableRowData[];

属性值

Excel.Interfaces.TableRowData[]

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. 只读。Read-only.

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

sort?: Excel.Interfaces.TableSortData;

属性值

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