Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Table → Get Columns

AI-generated

Summary

Retrieve a list of columns from a specified table in a Microsoft Excel workbook worksheet.

Inputs

  • Workbook (required) — Select the workbook containing the table, either from a list or by providing the workbook ID.
  • Sheet (required) — Select the worksheet containing the table, either from a list or by providing the sheet ID.
  • Table (required) — Select the table to get columns from, either from a list or by providing the table ID.
  • Return All — Choose whether to return all columns or limit the number of columns returned.
  • Limit — Specify the maximum number of columns to return if 'Return All' is false (default 50, max 500).
  • RAW Data — Optionally return the raw column data as received from the Microsoft Graph API instead of simplified names.
  • Data Property — When returning RAW data, specify the property name to write the raw data into (default 'data').
  • Filters — When returning RAW data, optionally use filters such as 'Fields' to select specific fields included in the response.

Output shape

a list of column records or a single record containing raw data

The output is an array of objects representing columns. Each column object contains a 'name' property unless 'RAW Data' is true, in which case it returns the raw API response under the specified 'Data Property'. The list respects the 'Return All' and 'Limit' settings. Errors are wrapped per item if 'Continue On Fail' is enabled.

Examples

Example 1: Get up to 50 columns from a table

Select workbook, sheet, and table; leave 'Return All' false and 'Limit' at 50; 'RAW Data' false.

Example 2: Get all columns as raw data

Select workbook, sheet, and table; enable 'Return All'; enable 'RAW Data'; specify 'Data Property' as desired.

Links

Discussion