Remove a Worksheet

Removes a specified worksheet.

Overview

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.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name
Data Type

the worksheet

Excel Worksheet

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 in the syntax.

Does it require input data?

⛔ No — This phrase does not require input data.

Examples

1. Remove the Excel Worksheet

get the excel's worksheet where
    the worksheet name is "Sheet1"
remove the worksheet

Last updated

Was this helpful?