About 65536 pandas can only read the excel form the problem!!!!!!!!!!-CodePudding

Found a problem: with pd. Read_excel read some 680000 lines of excel files, only went to the 65536 lines, very depressed, teacher consult everybody:
1, how to read completely? (just want to with pd. Read_excel method)
2, each version of excel file storage most line number is how many?
3, how to judge the excel in python version?
Thank you very much!!!!!!!!!!

CodePudding user response:

 
# installation openpyxl 
# PIP install openpyxl 

Engine # designated processing Excel file, the default use XLRD 
The import pandas as pd 
Df=pd read_excel (' datas. XLSX, engine='openpyxl')

https://blog.csdn.net/pythoncxy/article/details/100038420