How to read data from 2 different excel with different sheet names?

Help Forum
1

Hello,

I want to read the data from 2 different excel sheets with different sheet names. i am able to read the data from 1 excel sheet by providing the sheet name but unable to do it for second excel in loop. Kindly help me to resolve my issue.

Thanks

2

Hi,

Are you using Read Range Activity in the Excel Application Scope?
If yes that’s maybe an issue. Try to use Workbook Read Range Activity twice for the same file but a different sheet.

read_range

Hope it help.

3

But then again i need to use 2 different for each row activity to read the data, right?? i am attaching my workflow for your referenceMain.xaml (15.9 KB)

4

Hi @sneha_arbole

You can use Get Workbook sheets activity to get worksheet name from excel and then loop over the sheet name to retrive the data

image
image728×699 15.1 KB

Hope this helps you

Regards,

Nived N

Happy Automation

5

If you want to Read Range from two sheets and do exactly the same actions on both of the data tables you can use Merge Data Table Activity to create one dataTable from two.

6

Hello,
I am getting error

Screenshot (30)
Screenshot (30)1366×768 86.6 KB

7

Can u show the datatype of Vsheets

8

it is list of String