How to read Duplicate Column Names in Excel

Hi All,

Iam trying to read an Excel in which some duplicate column names exists.So when im using read range activity bot is throwing error saying like Column already belongs to the table.Is there any way to avoid the issue.

The highlted columns in yellow has same column names

hi @Aswini
you cannot read table with duplicate coulmn name
you have to change the duplicate or remove it before reading the table


The following post might help you.



Find the “AddHeaders” property and set it to False . This tells the “Read Range” activity not to use the first row as column headers.

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