I have a problem with detection of the column types when importing data into R using the read_excel function of readxl package.

There are lot's of Q&As that are similar to my issue like

code

df = pd.read_excel('data.xls',dtype={'a':str,'b':str})

output