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? UiPath: Main.xaml (9.4 KB) Excel: Test Email.xlsx (14.2 KB)

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

How to read range multiple excel sheets

hasib08 (Motiwala Hasib) April 9, 2020, 3:56am 2

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.

Worksheet.zip (22.4 KB)

2 Likes

How to read multiple sheet in excel

Topic		Replies	Views
How to read multiple sheets in excel Activities citrix , activities , question	2	177	May 16, 2024
How to read multiple sheet in excel Academy Feedback	5	6193	March 11, 2022
How to read data from 2 different excel with different sheet names? Forum question	7	1159	March 1, 2021
Read Multiple Excel Sheets Help	5	9044	October 29, 2018
Is it possible to read the multiple sheets using for each data table Help excel , uiautomation , activities	28	4765	October 29, 2018

How to read range multiple excel sheets

Related topics