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.
Write ActionRisk level 2 of 5OAuth connectionFree Action
Tool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.
addressThe A1-style address of the range to clear (e.g., 'A1:B2').
applyTostringOptional. The type of clear action. Possible values: All, Formats, Contents.
item_idRequiredstringThe ID of the Excel file (drive item) containing the worksheet.
site_idstringOptional. 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_idstringOptional 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_idstringOptional. 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_idRequiredstringThe name or ID of the worksheet (URL-encoded if necessary).
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.