workbookTableColumn resource type

Namespace: microsoft.graph

Important

APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.

Represents a column in a table.

Methods

Method	Return Type	Description
Get TableColumn	workbookTableColumn	Read properties and relationships of tableColumn object.
Update	workbookTableColumn	Update TableColumn object.
Databodyrange	workbookRange	Gets the range object associated with the data body of the column.
Headerrowrange	workbookRange	Gets the range object associated with the header row of the column.
Range	workbookRange	Gets the range object associated with the entire column.
Totalrowrange	workbookRange	Gets the range object associated with the totals row of the column.
Delete	None	Deletes the column from the table.
List	workbookTableColumn collection	Get tableColumn object collection.
Itemat	workbookTableColumn	Gets a column based on its position in the collection.
Add	workbookTableColumn	Adds a new column to the table.

Properties

Property	Type	Description
id	string	Returns a unique key that identifies the column within the table. Read-only.
index	int	Returns the index number of the column within the columns collection of the table. Zero-indexed. Read-only.
name	string	Returns the name of the table column.
values	Json	Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contains an error returns the error string.

Relationships

Relationship	Type	Description
filter	workbookFilter	Retrieve the filter applied to the column. Read-only.

JSON representation

The following JSON representation shows the resource type.

{
  "id": "1024",
  "index": 1024,
  "name": "string",
  "values": "json"
}