Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsExcel ToolsExcel Get Worksheet Used Range
Excel Tools

Excel Get Worksheet Used Range

Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells.

Write actionRisk level 2 of 5OAuth connection
Use Excel Get Worksheet Used Range

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • item_idstring
    Required
    The ID of the Excel file (drive item) containing the worksheet.
  • drive_idstring
    Required
    The ID of the drive (e.g., 'me' for the user's default OneDrive, or a specific drive ID for SharePoint).
  • session_idstring
    Optional workbook session ID. If provided, will be sent in the workbook-session-id header. Must be a valid session ID obtained from the createSession action.
  • values_onlyboolean
    If true, only returns cells with values (ignores formatting-only cells). Maps to valuesOnly parameter in the API.
  • worksheet_idstring
    Required
    The ID or name of the worksheet. Can be the worksheet name (e.g., 'Sheet1') or its unique ID.

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.