这里有一种方法你可以接近它。
该代码使用来自Pandas的to_excel()，然后使用openpyxl打开工作簿，并遍历注解DataFrame以在适用的地方添加注解。

import pandas as pd
from openpyxl import load_workbook
from openpyxl.comments import Comment

data = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
comments = pd.DataFrame({'A': ['Comment A1', None], 'B': [None, 'Comment B2']})
excel_path = "result.xlsx"
data.to_excel(excel_path, index=False)

wb = load_workbook(excel_path)
ws = wb.active

for row in comments.iterrows():
    xl_row = row[0] + 2  # +1 for 0-based index, +1 for header
    for xl_col, (col_name, comment_text) in enumerate(row[1].items(), 1):
        if pd.notna(comment_text):  # Check if the comment_text is not NaN
            cell = ws.cell(row=xl_row, column=xl_col)
            # change second arg to a name if you prefer
            cell.comment = Comment(comment_text, "Written by Python process")

wb.save(excel_path)

字符串