Get Sheet Names

The Get Sheet Names component in Robbot RPA enables you to obtain the names of all the sheets within an Excel file. You can use this component to retrieve the sheet names for further processing or to display them in your automation workflow.

Parameters

Result : Returns the sheet names in the Excel file as an array of strings. . Type : Array[String]

Usage

To use the GetSheetNames component in your Robbot RPA project, follow these steps:

Open your Robbot RPA project.

Drag and drop the GetSheetNames component to the activity adding section of the Open Excel component.

Continue building your sequence or workflow by adding other components or actions as needed.

After executing the GetSheetNames component, the result will contain an array of sheet names from the Excel file.

You can use the retrieved sheet names for various purposes within your automation workflow. For example, you can loop through the sheet names to perform operations on specific sheets or display the sheet names in a log or message box for verification purposes.

By using the GetSheetNames component, you can easily retrieve the sheet names in an Excel file and incorporate them into your automation processes in Robbot RPA