Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

Read and write Excel files in SharePoint (bypasses WAC token issues).

Table → Get Columns

AI-generated

Summary

Retrieve the column definitions for a selected Excel table in a SharePoint file using Microsoft Graph.

Inputs

  • Site (required) — Select a SharePoint site from the list or enter its ID.
  • Drive (required) — Select the document library or drive containing the file, or enter its ID.
  • File (required) — Select the Excel workbook (.xlsx) or enter its file ID.
  • Table (required) — Select the table in the workbook or enter its name.

Output shape

A list of items, one per table column.

Each item contains the column's id, name, and index. If the table has no columns, the operation returns one item with a message stating that no columns were found.

Links

Discussion