By using below code facing issue:
I am trying to read .xslx as well .xls file.
<code>df = pd.read_excel(filepath,sheet_name = "Package ID Informatio", header=hd, dtype=str)
</code>
<code>df = pd.read_excel(filepath,sheet_name = "Package ID Informatio", header=hd, dtype=str)
</code>
df = pd.read_excel(filepath,sheet_name = "Package ID Informatio", header=hd, dtype=str)
Code is running well in python3.7 version but facing issue while runing this issue in 3.12 version.
<code>File "C:Users\AppDataRoamingPythonPython312site-packagesopenpyxldescriptorsbase.py", line 61, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'datetime.datetime'>
</code>
<code>File "C:Users\AppDataRoamingPythonPython312site-packagesopenpyxldescriptorsbase.py", line 61, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'datetime.datetime'>
</code>
File "C:Users\AppDataRoamingPythonPython312site-packagesopenpyxldescriptorsbase.py", line 61, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'datetime.datetime'>
3