Rename duplicate headers in excel

Hai everyone,

I need to rename duplicate header in excel , anyone help me out of this issiue

Here is the link which will help in that case @veera_g

@veera_g instead of invoking custom code using Interop.Excel I would simply use the read range activity and DON’T check the ‘AddHeaders’ option. Then you can look through the first row of that datatable (that contains the column names) and change the column name if it’s a duplicate. Once you have changed the duplicate names (or removed those columns), then you can write it back to excel or just copy to a new datatable with the updated column names

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.