EXCEL Ensure sheet exists function

This article describes the RPA Excel functionality to ensure sheet exists.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Ensure sheet exists function allows you to ensure sheet exists.

Setting it up

To use the EXCEL Ensure sheet exists function, follow these instructions:

{{popups:rpas/add:action=excel-ensure-sheet-exist}}

Once on a process map:

1. Navigate to the process where you would like to add the EXCEL Ensure sheet exists function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the EXCEL Ensure sheet exists option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

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

Related functions

• excel-sheet-exist
• excel-add-sheet