How to take 2nd row as the header in to the new excel file

[Jyothi1 (Jyothi S)]

I have the data

the 2ndrow from Column B should be the header as sheet1=A2
same as that 3rd row from B should be the header as sheet2=A3

[Parvathy (PS Parvathy)]

Hi @Jyothi1

Check the below thread

How to get the header which is in second Row

@Gokul001 good catched the same col name scenario we can do: read range - A2 AddHeaders is unselected then unifying the col names by following: FixDuplicatedColNames.xaml (10.2 KB)

Regards

[lrtetala (Lakshman Reddy)]

Hi @Jyothi1

Use Read range activity with range as A2 and select add headers option and use Write Range activity

Regards,

[Jyothi1 (Jyothi S)]

please provide any correct solution like row need to picked and write as header in new excel sheet

[lrtetala (Lakshman Reddy)]

@Jyothi1

Can you try the below for 2nd row

@Jyothi1

2ndrow from Column B should be the header as sheet1=A2

NewDT=DT.AsEnumerable().Skip(1).Take(1).CopyToDataTable()

Input:

Output:

For 3rd row try below

@Jyothi1

3rd row from B should be the header as sheet2=A3

NewDT=DT.AsEnumerable().Skip(2).Take(1).CopyToDataTable()

Note:

Make Sure Uncheck Add Headers option in both Read Range and Write Range activities

Cheers!!

[Anil_G (Anil Gorthi)]

@Jyothi1

you can use a copy paste range as well directly

cheers