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

Help
, ,
1

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.

Regards,
Raja G

2

Hi @Raja.G

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

1 Like
3

Use GetWorkbookSheets activity

Use For Each Activity to loop thru each sheet.

Thanks @Raja.G

1 Like
4

Hi,
Check the below link to red all sheets of excel

1 Like
5

@Natapong,

This is my error

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

6

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

Thanks

1 Like
7

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)
ReadRange.zip (21.2 KB)

I hope it will be useful to you :smiling_face_with_three_hearts:

1 Like
8

@Natapong,

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

Na
Na1366×768 72.1 KB

9

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

2 Likes
10

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…