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
Required
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
Required
The name or ID of the worksheet (URL-encoded if necessary).
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