pandas写入表格 pd.to_excel()写入表格不同工作表、写入不同表格，不同工作表

写入表格不同工作表（工作表同名则覆盖）

import pandas as pd

writer=pd.ExcelWriter(ExcelFile,engine='openpyxl',index=True,encoding='utf-8-sig')
	df_titlerank.to_excel(writer,sheet_name='标题词权重计数')
	df_wordCount.to_excel(writer,sheet_name='标题词计数')
	writer.save()

写入不同表格，不同工作表（工作表同名不覆盖）

import pandas as pd
from openpyxl import load_workbook

book = load_workbook('Excel.xlsx')
writer=pd.ExcelWriter("Excel.xlsx",engine='openpyxl')
writer.book = book
df1.to_excel(writer,"first")
df2.to_excel(writer,"second")
writer.save()