Excel: Ensure sheet exists

Ensure 1 or more sheets exists.

Help Centre › Building Processes

Ensure 1 or more sheets exists.

Runs on: macOS and Windows only.

Add it to a process

In the process designer, open the Add step tab. Find Ensure sheet exists under Excel › Sheets, or type its name in the search box, and drag it onto the canvas.

Fields

FieldRequiredWhat it does
File pathNoEnter the file path, or use a variable such as {folders::desktop::path}\file.xlsx. Leave blank to use the workbook an earlier step opened.
SheetYesName of the sheet in the Excel file. Supports wildcards: * matches any characters.

See all Excel steps.

Errors

ErrorDescription
File not openThe Excel file must be open

Tips

  • If the sheet already exists, no action is taken
  • If the sheet does not exist, it is created

Related functions

Get started

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or have your first automation working in 7 days.