"使用pandas新增Excel工作表" 修訂間的差異
出自 YTYZX有图有真相的百科
(创建页面,内容为“import pandas from openpyxl import load_workbook book = load_workbook('Masterfile.xlsx') writer = pandas.ExcelWriter('Masterfile.xlsx', engine='openpyxl') writer.b...”) |
(無差異)
|
於 2022年3月20日 (日) 18:40 的最新修訂
import pandas from openpyxl import load_workbook
book = load_workbook('Masterfile.xlsx') writer = pandas.ExcelWriter('Masterfile.xlsx', engine='openpyxl') writer.book = book writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
data_filtered.to_excel(writer, "Main", cols=['Diff1', 'Diff2'])
writer.save()