Skip to main content

Write Range

Writes a range 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
Range AddressinAddressCell range to write (e.g. A1:D10 or A1)
TableinTableDataTable with columns array and rows array of objects (e.g. {columns:["name"٫"age"]٫rows:[{"name":"John"٫"age":30}]})
Workbook IDinWorkbookIDWorkbook ID from Open Workbook node
Worksheet NameinWorksheetIDWorksheet name (e.g. Sheet1٫ Sales)

Options​

PropertyFieldDescription
HeadersoptHeadersWrite column names as first row

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.

Read Range

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 19 more

See also​