Same Header from Datatable

[mbs_rishabh (Rishabh Mathur)]

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
RM

[kalyanDev]

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

[xuanhung (Hưng Nguyễn)]

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…