Excel

Insert Sheet

2min

Overviewο»Ώο»Ώ

Use this action to insert a new sheet into an existing workbook.

How to configure the Insert Sheet action?ο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώ

Step 1. Create a process and give it a name.

Step 2. Drag the Insert Sheet action to the canvas and link it to the other actions.

Document image
ο»Ώ

Step 3. Create the variables needed for the configuration of the action, and then add them to the configuration panel:

Document image
ο»Ώ
  • Excel workbook: you need to input the file with the workbook where you want to insert a new sheet
  • New sheet: you need to input a string variable with the name of the new sheet that you want to insert

Step 4. Save, Validate and Run the process.

Step 5. You will be prompted to add the file for the input variable. Click Run.

Step 6. To verify the process click Check instance.

Step 7. The file contains the new sheet added.