How to use two read range with "Add header" using uipath

Hi Guys,

I have different sheets in one excel in each sheet some row values to paste in another excel sheets specific row

I couldn’t able to use 2 read range activity “Add header” checked.

I need each sheet going to read ,but could able to read first sheet only

please can anyone help this.

Raja G

Hi @Raja.G

May I know the error that you are facing when read another sheet .

1 Like

Use GetWorkbookSheets activity

Use For Each Activity to loop thru each sheet.

Thanks @Raja.G

1 Like

Check the below link to red all sheets of excel

1 Like


This is my error

“Read Range: A column named ‘.’ already belongs to this DataTable.”

Ok, you can build your own Datatable, also don’t include the headers in excel sheet, because It will throw the same exception already belongs to this DataTable


1 Like

Hi @Raja.G

The cause of this error: data in first row is same with second row.

You need to read data from Excel files with specify range.
Please refer as below for guideline
(*Please chnge file path in below sample workflow first) (21.2 KB)

I hope it will be useful to you :smiling_face_with_three_hearts:

1 Like


thanks, but yours code first activity i couldn’t able to see,

Hi @Raja.G

This activity is BalaReva EasyExcel Activities,
You can refer as below to install it

It is a very nice activity for handle excel.
I use it for find Last column name


HI I am new to RPA can i read a column by its name? my column position is not fixed and i want to locate it by its name in my process… I tired to put the Column header in the Range but I’m getting error as it needs cell number…but i cant put cell number i need to find it by its name…is there a way to achieve thiss…