How to check if the name of the sheet in the list is in another Excel file

Help Activities
, ,
1

I did get the list of name of the sheet using GET Workbook sheets. After that, I want to check whether there is an Excel sheet in the list in the other Excel file and organize the activity using if.

But I don’t know how to do the find activity.

I would appreciate it if you could let me know the activity of finding out whether or not the sheet is in another Excel file using the sheet name list, or how.

If it’s on the list of sheet names but doesn’t have that sheet in another Excel file, I’d like to create a process to skip the action, and if there is, perform the action.

2

In your case - You already have the list of name of the sheets available in the first workbook

Do similar action for second excel file as well - Open the excel file and Get Workbook Sheets and store to a variable named as XlSheets_Destination

Now Start looping through the first List of sheets. You can use For Each activity

To check whether the current looping sheetname is available in the destination file - use below expression under if condition

XlSheets_Destination .contains(“YourSheetName”)

Hope it helps

Happy Automation

For reference:

A workflow checks worksheets in two Excel files and displays messages indicating whether each worksheet in the first file exists in the second file. (Captioned by AI)
A workflow checks worksheets in two Excel files and displays messages indicating whether each worksheet in the first file exists in the second file. (Captioned by AI)1195×1294 49.4 KB

ForumProject.zip (454.6 KB)

@sssim4567

3

Hello @sssim4567 ,

look at the below SnapShots for your solution :backhand_index_pointing_down:

The image shows two Excel Application Scopes in a workflow, each opening different Excel files ("excel 1.xlsx" and "excel 2.xlsx") and performing actions to get the workbook sheets. (Captioned by AI)
The image shows two Excel Application Scopes in a workflow, each opening different Excel files ("excel 1.xlsx" and "excel 2.xlsx") and performing actions to get the workbook sheets. (Captioned by AI)523×490 6.01 KB

Output of 1st get workbook = All_Sheets_1
Output of 2nd get workbook = All_Sheets_2

A workflow sequence in a software development environment checks if items from one list exist in another list and writes a corresponding message. (Captioned by AI)
A workflow sequence in a software development environment checks if items from one list exist in another list and writes a corresponding message. (Captioned by AI)595×586 15.4 KB

Let me know if this works, and don’t forget to mark it as solution.

Cheers!!!