Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

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

Sheet → Get Sheets

AI-generated

Summary

Lists the worksheets in the selected SharePoint Excel workbook, including each sheet’s name, ID, row count, and column count.

Inputs

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

Output shape

A single n8n item containing a sheets array.

Each array entry has name, id, rowCount, and columnCount. The operation downloads and reads the workbook; it does not modify it.

Links

Discussion