How to handle this exception


#1

datatable contains two different columns with same data. So this exception is thrown:
exception


#2

Follow below link


#3

Hi @mhk15,

Can you share the xml ?

Regards
Balamurugan


#4

Hi @mhk15

Looks like you have set Add Headers to True for the Read Range activity. This means the first row of the Excel will be considered as Column Headers in the DataTable (the output of Read Range), apparently in your Excel the first row doesn’t seems to be a Header but a value (going by 9.00 %74.90.). And these value is duplicating within the first row. A DataTable’s Column header cannot duplicate (Case-sensitively)

One Solution is you can build the DataTable first by creating the Columns with its Headers by giving unique Column header names and then use in the Read Range activity