I need to change the names of few headers in an excel file. While reading the excel file with add headers enabled I get the following error " A column named ‘PNR’ already belongs to this datatable.
Hence I’m trying to rename the Headers with add Headers disabled.
I need to rename the following Headers:
1.PNR = "PNR " - cell reference A45
2.ACI IND = "ACI IND " - cell reference A82
3.POS CNTRY = "POS CNTRY " - cell reference A95.
I have attached the excel attachment for reference
Sample.xlsx (9.3 KB)
Any help or leads to solve the issue is much appreciated.