I am trying to copy entire text from an excel file and paste it to another. I am using ReadRange from excelsheet 1 and WriteRange to excelsheet2.
Since I have some duplicate columns as a part of the excelsheets, i am getting the following error.
MasterDataPrep has thrown an exception
Message: A column named ‘ABC’ already belongs to this DataTable.
Source: Read range
Exception Type: DuplicateNameException
I have charts inside the excelsheet2 because of which I cannot use Excel Application Scope. Please suggest the solution for the DuplicateNameException error message.