Excel has duplicate Header columns unable to read it using Read Range Activities

Help Something Else
1

Hi Team,

I have an excel which contains duplicate header column’s due that unable read the excel .We need to delete/rename them and get specific column data .
In below screen shot F and G are duplicate header’s.
I need only Sta. row value every time it will be on same position .

Example .

image
image1783×348 30.4 KB

Regards ,
Suresh.T

2

Hi @Thumu_Suresh

Welcome to UiPath community

You can try with read range activity

In the Range → You can use specific range "J1"

image
image904×196 4.39 KB

Regards
Gokul

3

Hi,

A sample in the following post will help you.

image
image882×1447 36.4 KB

Regards,

4

Uncheck the headers property of read range. You can either start the range at A1 and the column names will be row 1 in your datatable, or you can just start at A2 and ignore the column names altogether.

5

Sequence.xaml (10.3 KB)

use the attached sequence.xaml

6

Hi Sanjit ,

It is working for renaming the columns but how can i get the specific column data.

image
image1774×203 11.1 KB

I need value in Valcl column .only one specific column data .

7

you mean you want only that column from the whole datatable ?

8

I need the value 3100

9

will you have only 1 row in the datatable always?

10

Yes ,every time one column.