Skip to main content

Get Row

Gets a row in Microsoft Excel 365.

This node is also exposed as an AI Agent tool.

This node has 1 input port and 1 output port.

Common Properties​

Every node shares these.

  • Name — the node's display name on the canvas.
  • Color — the node's colour on the canvas.
  • Delay Before (sec) — wait this long before the node runs.
  • Delay After (sec) — wait this long after the node runs.
  • Continue On Error — carry on instead of failing the flow. Defaults to false.
info

When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.

Inputs​

PropertyFieldDescription
Row NumberinRowNumberRow number (1-based٫ e.g. 2 for first data row if row 1 has headers)
Workbook IDinWorkbookIDWorkbook ID from Open Workbook node
Worksheet NameinWorksheetIDWorksheet name (e.g. Sheet1٫ Sales)

Outputs​

PropertyFieldDescription
RowoutRowJSON object with column names as keys (or column letters A٫B٫C if no headers)

Options​

PropertyFieldDescription
HeadersoptHeadersFirst row contains column headers (used as keys in output object)
Include HyperlinksoptIncludeHyperlinksInclude hyperlink info (values become objects with text and hyperlink properties)
JsonifyoptJsonifyConvert column names to lowercase with underscores (e.g. Price Range -> price_range)

Requirements​

  • Azure AD App (Client Credentials) — Use Azure AD app registration with client credentials for server-to-server authentication.
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID (Directory ID)
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret
    • user_email — User Email (Optional) (text, optional). Email of user whose OneDrive to access. Required for accessing user's OneDrive files.
  • OAuth2 (Delegated) — Authorize via browser to access Excel files on behalf of a user.
    • _redirect_url — Redirect URL (readonly, optional). Add this to your Azure app's Redirect URIs
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID، or 'common' for multi-tenant
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret

Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.

Set Row · Append Row · Delete Row

Elsewhere in the package: Open Workbook · Close Workbook · Create Workbook · List Workbooks · Get Workbook · List Worksheets · Create Worksheet · Delete Worksheet · List Tables · Create Table and 17 more

See also​