import pandas as pd
df=pd.read_excel(r'C:\Users\Administrator\Desktop\02测试.xls',"1")
df.dropna(axis=0,how="all",inplace=True)#删除excel空白行代码
df.dropna(axis=1,how="all",inplace=True)#删除excel空白列代码
df.to_excel(r'C:\Users\Administrator\Desktop\02测试.xls',"1")
注:axis=0表示操作excel行,axis=1表示操作excel列