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)
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
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