Listing of sheet tab names in a Excel file that do not exist in another Excel file

How do I list the sheet tab names in HEHE Excel file that do not exist HAHA Excel file? Thank you. HAHA.xlsx (11.1 KB) HEHE.xlsx (11.5 KB) Solution in Copy paste.xaml (19.5 KB)

@ROBERT_RUSSELL_MONSA

the get worksheets Activity returns a list of worksheet names

Getting the differences
within an assign activity following statement returns the difference
HahaWSNamesList.Except(HeheWSNamesList).toList

1 Like

Hi @ROBERT_RUSSELL_MONSA

Use excel application scope in excel workbook variable create a workbook
and use for each item in wb.get sheets.except(“sheetname2”)

print the item

Thanks
Ashwin S

1 Like