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
But There are columns with the same name…so how to ignore that?
HandleDuplicateColumns.zip (11.9 KB)
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 ?
Read by unchecking the ‘Add Headers’ property of Read Range
sure I will try.