The Data available in the excel is having duplicate header name so if we attempt to read the table from A: F with read header On - we would not be able to read as DataTable cannot have duplicate headers.
we cab Read the Data without Header and then Uiptah will assign Header Names as Column0, column 1 and so on.
3.For Renaming , then we can use : column0 , column1 - To get these names - you can run the process in debug mode and quick watch the Datatable after the excel read.
thanks for your reply @mukeshkala , I forgot to say that as you have already explained well, I know that removing hearder to read range activity I will have “Column1,…”, but do you know how to use Replace method even with this problem already highlighted???