I am exporting one excel file from SAP system which two duplicate columns i.e . Old Value and New Value. I wanted delete Column K and L after that only I can apply filter on Changed by Column.
When I am reading it in read range it is throwing error. Please help.
Then maybe try read range and deselect the use first row as headers option. Change the first row values, save the Excel file and try reread it with first row as headers selected