website logo
πŸ”­Overview
πŸ’ΌPlatform Actions
πŸ’œIntegrations
🧰Custom Actions
πŸ› οΈDeveloper's Guide
Navigate through spaces
⌘K
πŸ“•Call API
πŸ“•Generate Document
πŸ“•Call Subprocess
πŸ“•Decisional
βš“Decisional Further Reading
πŸ“•Join
πŸ“•Delay
πŸ“•For Each
πŸ“•Get File Data
πŸ“•Map Process Data
βœ‰οΈSend Email
πŸ“¬Inbound email
πŸ“Database
πŸ“Documents
πŸ“DateTime
πŸ“FTP/sFTP
πŸ“Json
πŸ“XPath
πŸ“Lists
πŸ“Numerical
πŸ“Strings
πŸ“Converters
πŸ“Excel
πŸ“Scripting
πŸ“Utilitary
πŸ“Pdf
πŸ“Beta
Docs powered byΒ archbeeΒ 

Delete Sheet

3min

Overviewο»Ώο»Ώο»Ώο»Ώ

Use this action to delete a sheet by name from an existing workbook.

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

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

Step 2. Drag the Delete 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 delete the sheet
  • Sheet name: you need to input a string with the sheet name which you want to delete

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. Open the file; it will no longer contain the deleted sheet.

Updated 31 Mar 2023
Did this page help you?
Yes
No
PREVIOUS
Rename Sheet
NEXT
Apply Formula
Docs powered byΒ archbeeΒ 
TABLE OF CONTENTS
Overviewο»Ώο»Ώο»Ώο»Ώ
How to configure the Delete Sheet action?ο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώ