I want to read whole data with add header. but there is one duplicate name so can’t read whole data because of its showing duplication Error. Now guys please help me to handle this ?
Bro Actually excel columns are also dynamic so how can we find out specific column name??
entire approach works dynamicly anf if any duplicate columname is found it is adding a counter
simulating read range without add headers. We do find the column names in first row:
after correction the datatable looks like this: