How to read range multiple excel sheets

My objective is to send an email to the people who indicated ‘N’ under the column ‘UPDATED?’. However, I have 2 sheets (Sheet1 and Sheet 2). How do I read range the multiple sheets and combine them into one output Data Table?

Main.xaml (9.4 KB)

Test Email.xlsx (14.2 KB)

You can read all the sheets separately using read range and paste it on the first sheet using Append Range activity, if only you have the same structure in all the sheets. (22.4 KB)

1 Like

@foppishinc Can you Check this xaml :
Main.xaml (10.7 KB)

thank you, this works!

What if my sheet names are actually ‘A’, ‘B’, ‘C’ and so on. What should I change in the workflow?

@foppishinc Note that this workflow works only when you have the same Format of Excel, the Column Headers need to be the same in all the Sheets.

And can you replace the “Sheet1” name in First Read Range with SheetNames(0), This Should make it dynamic and you don’t need to worry if the Sheet names are changing but the Headers in all Sheets needs to be the same.

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