I have multiple excel files and I’m having an issue processing them. Some of the files have columns with the same name what generates an error.
There is a way to run through all excel files and rename the repeated column?
For example, I have to columns name “description” and I want to rename the second appearance to “description_2”.
But I want to do some operations and checks with the column headers (if they have spaces before or after, etc). But the files that are sent to me have columns with the same name. What I want is read the headers and do this operations, and if I found a column with the same name of a previous column in that excel file, change the name of the second one
@joaotavares1996 Do you know the order of Columns and if so can you put the Order of new Column names in an array of Strings, In this way you can use this array of String to rename the Columns using for Each