Add a Worksheet

Adds an empty worksheet to an existing Excel file.

Overview

This procedure adds an empty worksheet to an existing Excel file (workbook), provided a worksheet name.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

add a worksheet to the excel where

What does it do?

References an Excel file to add a worksheet to.

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 excel must be defined in the automation.

the worksheet name is "worksheet-name"

What does it do?

Specifies the name of worksheet to be added to the Excel file.

Where does it go?

Indented under add a worksheet to the excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace worksheet-name with the name of the worksheet to be added.

Example

the worksheet name is "New Sheet"

Examples

1. Adding a Worksheet to an Excel

This example create a new excel file and add a worksheet to it.

create an excel where
    the file name is "purchase_orders.xlsx"
add a worksheet to the excel where
    the worksheet name is "Summary"