Skip to main content
Kofax

Extract Excel Worksheet Name Dynamically

Article # 3048800 - Page views: 28

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.

1.png

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

2.png

 

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
RPA

10.x

11.x

     

 

 

Article # 3048800
  • Was this article helpful?