Create an Excel File

Creates a new Excel file.

Overview

This procedure create a new Excel file (workbook). Worksheet names can be optionally specified to add empty worksheets.

Syntax

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

create an excel where

What does it do?

Initializes the creation of an Excel File.

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?

❌ No — This phrase does not require data.

the file name is "workbook-name.xlsx"

What does it do?

Specifies the name of the Excel file to create.

Where does it go?

Indented under create an excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace workbook-name.xlsx with a text value.

Example

the file name is "my_workbook.xlsx"

the worksheet names are "worksheet-name1", "worksheet-name2", "worksheet-name3"

What does it do?

Specifies the names of the worksheets to create in the Excel file.

Where does it go?

Indented under create an excel where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace worksheet-name1, worksheet-name2, worksheet-name3 with the names of the worksheets to be added. You can specify one worksheet name or multiple worksheet names separated by a comma.

Example

the worksheet names are "Flights", "Purchases", "Sales"

Examples

1. Create Excel with Multiple Worksheets

create an excel where
    the file name is "my_workbook.xlsx"
    the worksheet names are "Sheet1", "Sheet2", "Data"

2. Create Excel with Single Worksheet

create an excel where
    the file name is "single_sheet_test.xlsx"
    the worksheet names are "Sheet1"

3. Create Excel with Default Worksheet

create an excel where
    the file name is "simple_workbook.xlsx"