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 ?
The following topic might help you.
find starter help here:
FixDuplicatedColNames.xaml (9.7 KB)
@ppr , thanks for the solution. This is exactly what I was looking for.