pandas操作excel读写

import pandas as pdxlsfile = r'D:\workfile\uv\wind.xls'df0 = pd.read_excel(xlsfile,0,index_col = None,na_values= ['9999'])df1 = pd.read_excel(xlsfile,1,index_col = None,na_values= ['9999'])#index_col拿出某列作为indexwith pd.ExcelWriter('newxls.xls') as writer:    df0.to_excel(writer,sheet_name = str(0))    df1.to_excel(writer,sheet_name = str(1))