excel_file='456.xlsx'xd=pd.ExcelFile(excel_file)#遍历每一个sheetforiinxd.sheet_names:#print(i,type(i))#读取指定sheetdf = xd.parse(sheet_name=i) pd.set_option('colheader_justify','center')#FOR TABLE <th>html_string ='''<html> <head><title>HTML Pandas Dataframe with CSS</title>...
df=xd.parse(sheet_name=i)pd.set_option('colheader_justify','center')#FORTABLE<th>html_string='''<html><head><title>HTMLPandas DataframewithCSS</title></head><link rel="stylesheet"type="text/css"href="df_style.css"/><body>{table}</body></html>.''' #OUTPUTANHTMLFILE# 创建excel...