Extract Excel Worksheet Name Dynamically

Issue

Is there a way to extract the name of an Excel worksheet that changes every time the robot processes the Excel file?

Solution

Yes. Use the Loop Sheet step and an Extract Sheet step. The Loop Sheet step will index each sheet in the file. The Extract Sheet step uses the indexed range (sheet) to retrieve the sheet's name.

Configure the Extract Sheet Name step's Finders tab as follows:

Level of Complexity 

Easy

Applies to