【RPA】XLXS 文档生成器（Python 篇）

1. 安装

1. 按住WIN+R输入 cmd；启动命令行提示符，键入 pip install python-pptx

pip install pillow
pip install openpyxl

2. 样例

from openpyxl import Workbook
wb = Workbook()

# grab the active worksheet
ws = wb.active

# Data can be assigned directly to cells
ws['A1'] = 42

# Rows can also be appended
ws.append([1, 2, 3])

# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()

# Save the file
wb.save("样例.xlsx")

参考资料

官方文档地址：https://openpyxl.readthedocs.io/en/stable/#