I have a situation where I need to export a datatable to excel. I am making use of the aspose.cells ImportDataTable function. This function works great but I am having one problem. This excel document is being used for an import into another DB (unfortnately) and the person that initially created this template allowed there to be duplicate column names. The column will be named the same but contain different data. What I have noticed is that when I push the datatable to Excel using the ImportDataTable function it renames duplicate columns by adding a “1” to the end of the column name. Do you have any suggestions on ways to prevent the software from renaming the columns?
Please send us the templete file which contains the duplicate columns and sample code. This will help us find the root cause of the issue. We will look into this and will update you accordingly.