Please refer below Sheet and my required output is the range of the sheet i.e A3:CM15

Book1.xlsx (10.8 KB)

Use read range activity under excel activities or workbook activities. You can mention this range in that activity and read output to data table

Thanks @Surya_Narayana_Korivipadu

But There are columns with the same name…so how to ignore that?

HandleDuplicateColumns.zip (11.9 KB)

Hi @Priyansh,

You refer this code to handle duplicate columns.
Let me know if you face any issue

Thank You @ermanoj3101

we can’t change formatting buddy. we have to keep same header name.so how to do that?

You can use it at run time but in the end just do write range without headers.
Old Headers need to put on zero row as a value.

Correct me if i am wrong ?

@Priyansh

Read by unchecking the ‘Add Headers’ property of Read Range

image

@ermanoj3101

sure I will try.

Thanks @kumar.varun2