My Excel file have 2 colums with same header and the file is generated form a finance system.
Column C header is = “Item Type”
Column D header is also = “Item Type”
But the values in column C is number and value in columns D is description.
I can not read this file as preserve format how to solv this…
Act im reading the file first and save data to an output variable then i use the same output data to edit the columns names.