Same Header from Datatable

Hello i am facing a problem of saving datatable in excel file

As you can see the Headers “Sub Total” occurs two times.
and when i read the data from excel file then i got an error : A column named ‘Sub-Total’ already belongs to this DataTable…
can anyone help me on this.

Thannks in advance

If want to read the the excel headers must be unique.
otherwise read the excel by giving fixed range.

1 Like

You should uncheck add header of read range activity.And read from A2 cell.
After that, your header out Datatable like this: Column0, Column1, Column2…

1 Like