Pandas version checks

  • [X] I have checked that this issue has not already been reported.

  • [X] I have confirmed this bug exists on the latest version of pandas.

  • [ ] I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

import pandas as pd
df = pd.read_excel('temp.xlsx', dtype=str)


=> ValueError: invalid literal for int() with base 10: 'NaN'

Issue Description

I specified "dtype=str" in the read_excel option, why is conversion to int first attempted?

Expected Behavior

I want it to be converted to a string without any errors.

Installed Versions

python : 3.7.3.final.0 python-bits : 64 OS : Windows OS-release : 10 pandas : 1.3.5 numpy : 1.21.6

Comment From: phofl

Hi, thanks for your report. Can you please provide a reproducible example?

Comment From: phofl

Closing for now, please ping to reopen when you can provide an example