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.

价格

免费操作

统一支付

暂不支持

• item_idstring

  必填
  The ID of the Excel file (drive item) containing the worksheet.
• drive_idstring

  必填
  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

  必填
  The ID or name of the worksheet. Can be the worksheet name (e.g., 'Sheet1') or its unique ID.

• data

  必填
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必填
  Whether or not the action execution was successful or not

尚未关联经过验证的相关使用场景。