Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

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

Actions13

Sheet → Get Rows

AI-generated

Summary

Reads rows from a worksheet in an .xlsx file stored in SharePoint. It downloads the whole file via Microsoft Graph, parses it with ExcelJS, and returns each data row as an item keyed by header name, or as one raw-array item.

Inputs

  • Site (required) — SharePoint site, chosen from a searchable list or entered as a site ID (e.g. contoso.sharepoint.com,site-guid,web-guid).
  • Drive (required) — Document library/drive containing the file, chosen from a list or entered by ID.
  • File (required) — The .xlsx file, chosen from a list or entered by ID. The list only shows .xlsx files in the drive's root folder; use By ID for files in subfolders.
  • Sheet (required) — Worksheet name, chosen from a list or typed. Errors if the sheet is not found.
  • Return All — Default true. When false, the Limit field applies.
  • Limit — Maximum number of non-empty data rows to return (default 50, minimum 1). Only used when Return All is off.
  • Options > Header Row — 1-indexed row holding column headers (default 1). Empty header cells are skipped. A header cell with an empty value is named ColumnN.
  • Options > Start Row — First data row to read, 1-indexed (default 2).
  • Options > Fields — Comma-separated column names to include. Empty means all columns.
  • Options > RAW Data — When true, returns one item containing the headers and a 2D array of rows instead of one item per row.
  • Options > Data Property — Property name that holds the raw rows array when RAW Data is on (default 'data').

Output shape

By default, one item per non-empty row, with header names as keys and cell values as values. With RAW Data, a single item {headers: [...], : [[...], ...]}.

Only the first input item's parameters are used. The node runs once and does not loop over input items. Rows with all-empty cells are skipped. In keyed mode, empty cells are omitted from the object. In raw mode, empty cells are null. If no data is found, a single item {message: 'No data found in sheet'} is returned. Values are the ExcelJS cell values, so formulas and rich text can come back as objects rather than plain values. The operation is read-only, but it downloads the entire file each run. Errors (including a 423 file-locked error) throw, or return {error} if Continue On Fail is enabled.

Examples

Example 1: Read all rows of a customer list sheet.

Select Site, Drive, File and Sheet 'Customers'. Leave Return All on and the options at their defaults.

Example 2: Pull only the Name and Email columns from the first 100 rows of a sheet whose headers are on row 3.

Return All off, Limit 100. Options: Header Row 3, Start Row 4, Fields 'Name, Email'.

Example 3: Get the sheet as a 2D array for custom processing.

Options: RAW Data on, Data Property 'rows'.

Links

Discussion