Hi All I want to download a report from a webpage in excel format. But the report contains two columns with same names. Then while using read range its throwing error. I cant untick Add Headers property as i need all the headers in my automation. How can i handle such scenario ?

How to handle read range if an excel contains two same columns names?

ppr (Peter Preuss) May 6, 2021, 7:57am 3

5 Likes

Check column name if found header same

Topic		Replies	Views
How to read Duplicate Column Names in Excel Activities excel	4	913	August 3, 2023
Excel has duplicate Header columns unable to read it using Read Range Activities Something Else feedback	9	1945	December 19, 2022
How to Read Excel data with duplicate name and how to handle this? Activities excel	3	780	April 12, 2021
While iterating the list of excel using read range activity it throws an duplicate column name error Learning Hub excel , activities	14	1547	March 17, 2020
Check column name if found header same Activities excel , activities , question	5	1555	March 7, 2022