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.
Does it require input data? ⛔ No — This phrase does not require input data.
Is it required? ✅ Yes — This phrase is required in the syntax.
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.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? ✅ Yes — This phrase is required in the syntax.
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.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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"