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

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 .

Regards ,
Suresh.T

Hi @Thumu_Suresh

Welcome to UiPath community

You can try with read range activity

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

Regards
Gokul

Hi,

A sample in the following post will help you.

Regards,

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.

Sequence.xaml (10.3 KB)

use the attached sequence.xaml

Hi Sanjit ,

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

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

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

I need the value 3100

will you have only 1 row in the datatable always?

Yes ,every time one column.