python-pandas中pd.to_excel()一个excel文件保存多个工作表。
import pandas as pdA = [[1,2,3],[4,5,6]]B = [[7,8,9],[10,11,12]]df1 = pd.DataFrame(A)df2 = pd.DataFrame(B)from openpyxl import load_workbook #先创建一个 2017.xlsx 文件book = load_workbook("2017.xlsx")writer = pd.ExcelWriter("2017.xlsx", engine='openpyxl')





