Microsoft Excel 365 icon

Microsoft Excel 365

Consume Microsoft Excel API

Actions16

Table → Get Columns

AI-generated

Summary

Lists columns in a selected Excel table in a workbook and worksheet, with optional pagination, raw output, and field filtering.

Inputs

  • Workbook (required) — Select a workbook from the list or enter its ID.
  • Sheet (required) — Select a worksheet or enter its ID.
  • Table (required) — Select a table or enter its ID.
  • Return All — When enabled, return all columns; otherwise return up to the Limit.
  • Limit — Maximum columns to return when Return All is disabled; defaults to 100, with a UI range of 1–500.
  • RAW Data — Whether to return raw API data instead of parsing values into keys based on the table header.
  • Data Property — Property name for raw data; defaults to data.
  • Filters: Fields — Comma-separated list of response fields to include.

Output shape

A list of items, each representing a table column.

The response is limited by Limit unless Return All is enabled. With RAW Data enabled, the result is placed under the configured Data Property; otherwise, data is parsed according to the table header.

Links

Discussion