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"
