Edit

Share via

Excel.Interfaces.TableColumnData interface

Package:
excel

An interface describing the data returned by calling tableColumn.toJSON().

Properties

filter

Retrieves the filter applied to the column.
id

Returns a unique key that identifies the column within the table.
index

Returns the index number of the column within the columns collection of the table. Zero-indexed.
name

Specifies the name of the table column.
values

Represents the raw values of the specified range. The data returned could be a string, number, or boolean. Cells that contain an error will return the error string. If the returned value starts with a plus ("+"), minus ("-"), or equal sign ("="), Excel interprets this value as a formula.
valuesAsJson

A JSON representation of the values in the cells in this table column. Unlike TableColumn.values, TableColumn.valuesAsJson supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the en-US locale. To retrieve data in the user's display locale, use TableColumn.valuesAsJsonLocal.
valuesAsJsonLocal

A JSON representation of the values in the cells in this table column. Unlike TableColumn.values, TableColumn.valuesAsJsonLocal supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the user's display locale. To retrieve data independent of locale, use TableColumn.valuesAsJson.

Property Details

filter

Retrieves the filter applied to the column.

filter?: Excel.Interfaces.FilterData;

Property Value

Excel.Interfaces.FilterData

Remarks

[ API set: ExcelApi 1.2 ]

id

Returns a unique key that identifies the column within the table.

id?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.1 ]

index

Returns the index number of the column within the columns collection of the table. Zero-indexed.

index?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.1 ]

name

Specifies the name of the table column.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.1 for getting the name; 1.4 for setting it. ]

values

Represents the raw values of the specified range. The data returned could be a string, number, or boolean. Cells that contain an error will return the error string. If the returned value starts with a plus ("+"), minus ("-"), or equal sign ("="), Excel interprets this value as a formula.

values?: any[][];

Property Value

any[][]

Remarks

[ API set: ExcelApi 1.1 ]

valuesAsJson

A JSON representation of the values in the cells in this table column. Unlike TableColumn.values, TableColumn.valuesAsJson supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the en-US locale. To retrieve data in the user's display locale, use TableColumn.valuesAsJsonLocal.

valuesAsJson?: CellValue[][];

Property Value

Excel.CellValue[][]

Remarks

[ API set: ExcelApi 1.16 ]

valuesAsJsonLocal

A JSON representation of the values in the cells in this table column. Unlike TableColumn.values, TableColumn.valuesAsJsonLocal supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the user's display locale. To retrieve data independent of locale, use TableColumn.valuesAsJson.

valuesAsJsonLocal?: CellValue[][];

Property Value

Excel.CellValue[][]

Remarks

[ API set: ExcelApi 1.16 ]