首先需要安装模块openpyxl
使用命令如下：
.pip3.exe install openpyxl
如下：
后面就可以一顿操作猛如虎代码如下：
from openpyxl import Workbook
from datetime import datetime
wb = Workbook()
ws = wb.active
print(ws.title)
ws.title ="道亦无名的书库"
ws["A1"]="书名"
ws["B1"]="数量"
ws["C1"]="添加时间"
ws.append(["水浒传","2",datetime.now().strftime("%Y-%m-%d")])
ws.append(["金瓶梅","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["西游记","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["三国演义","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["水浒传","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["红楼梦","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["醒世姻缘传","3",datetime.now().strftime("%Y-%m-%d")])
ws.append(["儒林外史","3",datetime.now().strftime("%Y-%m-%d")])
wb.save("测试表格.xlsx")
结果如下：
