Filter excel files by sheet

Help Studio
, ,
1

I have a folder with some specific excel files but I only need my robot to read the files that contain a sheet called RPA, if the robot detects that the excel file does not contain that sheet it must exit the cycle, how can I do this?
Sorry if my english is bad

2

Use the Excel Applications Scope, and within that, use Get Sheets. This will return an array of the names of each sheet in the workbook. Then use an If statement with condition Not Sheets.Contains("RPA"), where Sheets is the string array variable where you store the array of sheet names. If this returns True, it means there was no sheet called “RPA”. You can put a Terminate Workflow activity in here to end the process.

2 Likes
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.