Excel Clear Range

Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.

价格

免费操作

统一支付

暂不支持

• addressstring

  必填
  The A1-style address of the range to clear (e.g., 'A1:B2').
• applyTostring
  Optional. The type of clear action. Possible values: All, Formats, Contents.
• item_idstring

  必填
  The ID of the Excel file (drive item) containing the worksheet.
• site_idstring
  Optional. The SharePoint site ID (format: hostname,site-collection-id,site-id). Required when using application permissions (s2s_oauth) with SharePoint files. Not needed for OneDrive files with delegated permissions.
• drive_idstring
  Optional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
• session_idstring
  Optional. The workbook session ID for persistent changes. Must be obtained from EXCEL_GET_SESSION (createSession API) - do not construct manually. Format starts with 'cluster=' followed by session data. Invalid or expired sessions will cause API errors.
• worksheet_idstring

  必填
  The name or ID of the worksheet (URL-encoded if necessary).

• 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

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