相关链接:https://pypi.org/project/xltpl/
from xltpl.writerx import BookWriter def fix_info_excel(): """填充xxx信息的excel表格""" writer = BookWriter('./xxx信息表.xlsx') ws_info_map = { "sheet_name": "xxxx提供表", "tpl_idx": 0, "client": "xxx科技", "td_no": "58888", "bug_description": "没电了", "reason": "这是啥原因", "reappear_advise": "复现建议", "fix_notes": "改动说明", "test_advice": "测试建议", "git_path": "git地址", "is_warn": "否", "plan_to_finished_date": "2020-06-15", "add_user": "ldd" } sheet_info = { "xxx开发提供表": ws_info_map, "文件的MD5值": { "sheet_name": "文件的MD5值", "tpl_idx": 1, }, } writer.render_book(sheet_info) writer.save('xxxwww信息表.xlsx')
说明:这个Python库的在模板表格中的单元格有批注的情况下,批注的样式不会保留,同时如果有多个sheet,需要注意传入sheet_info的参数的形式。