This procedure removes a specified worksheet from an Excel File. In automation flows, it is useful for cleaning up intermediate sheets that are no longer needed after data processing steps. It helps maintain a clean and predictable workbook structure across runs, especially when regenerating reports, refreshing data, or preparing files.
Be sure to verify the worksheet name before deletion to avoid accidental data loss!
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
remove the worksheet
What does it do?
References a worksheet in an Excel file to remove.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — A reference to the worksheet must be previously defined in the automation.
Examples
1. Remove the Excel Worksheet
get the excel's worksheet where
the worksheet name is "Sheet1"
remove the worksheet