如何在已经存在的excel文件中增加新的工作表?
分类:Python
要修改现有的excel文件,代码怎么写呢?谢谢
2个回复
-
xsmile
方法一:使用xlutils.copy
import xlrd, xlwt
from xlutils.copy import copy as xl_copy# open existing workbook
rb = xlrd.open_workbook('ex.xls', formatting_info=True)
# make a copy of it
wb = xl_copy(rb)
# add sheet to workbook with existing sheets
Sheet1 = wb.add_sheet('Sheet1')
wb.save('ex.xls')
方法二:使用openpyxl库import openpyxl
wb=openpyxl.load_workbook(r'ex.xlsx')
wb.create_sheet(title='Sheet2',index=0)
wb.save(r'ex.xlsx')作者:海爷爷
原文: https://blog.csdn.net/zh54b5n64vn64654/article/details/811016813年前 我来评论 -
xsmile
from openpyxl import load_workbook book = load_workbook('a.xlsx') writer = pd.ExcelWriter('a.xlsx', engine='openpyxl') writer.book = book df1.to_excel(writer, 'sheet1') df2.to_excel(writer, 'sheet2') writer.save() 参考 http://www.cnblogs.com/meitian/p/10466198.html
3年前 我来评论