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 to the file. This is useful in scenarios where a consistent file structure is needed as a starting point for future data entry or automation.

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

Does it require input data?

⛔ No — This phrase does not require input data.

the file name is

What does it do?

Specifies the name of the Excel file to create.

Where does it go?

This phrase should be indented beneath create an excel where.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

✅ Yes — A Text value should be specified.

the worksheet names are

What does it do?

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

Where does it go?

This phrase should be indented beneath create an excel where.

Is it required?

🌟 No — This phrase is optional in the syntax.

Does it require input data?

✅ Yes — A Text value should be specified.

Examples

1. Create an Excel File with a Specified File Name and Worksheet Names

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