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Β 

Get Sheet Names

4min

Overviewο»Ώο»Ώ

Use this action to capture all sheet names from an existing workbook.

How to configure the Get Sheet Names action?ο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώ

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

Step 2. Drag the Get Sheet Names 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 enter the workbook file from which all the sheet names will be extracted
  • Sheet names: the output contains a variable of type list<string> which will store the sheet names

Step 4. Save, Validate and Run the process.

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

Step 6. To verify the process click Check instance.

Step 7. In the Output section, you can see the list with sheet names:

Document image
ο»Ώ

ο»Ώ

Updated 31 Mar 2023
Did this page help you?
Yes
No
PREVIOUS
Create Workbook
NEXT
Insert Sheet
Docs powered byΒ archbeeΒ 
TABLE OF CONTENTS
Overviewο»Ώο»Ώ
How to configure the Get Sheet Names action?ο»Ώο»Ώο»Ώο»Ώο»Ώο»Ώ