我看到了一些关于如何使用openpyxl将pandas DataFrame添加到现有工作表的答案,如下所示:
from openpyxl import load_workbook, Workbook
import pandas as pd
df = pd.DataFrame(data=["20-01-2018",4,9,16,25,36],columns=["Date","A","B","C","D","E"])
path = 'filepath.xlsx'
writer = pd.ExcelWriter(path, engine='openpyxl')
writer.book = load_workbook(path)
writer.sheets = dict((ws.title,ws) for ws in writer.book.worksheets)
df.to_excel(writer,sheet_name="Sheet1", startrow=2,index=False, header=False)
writer.save()
然而,我需要将背景数据设置为高亮颜色。有没有一种方法可以在不将数据框转换为列表的情况下实现这一点 - 并尝试保持日期格式呢?
谢谢