import datetime
now = datetime.datetime.now()
print("当前系统日期是：")
print(now.strftime("%Y-%m-%d %H:%H:%M:%S"))
a = input("请输入你的姓名：")
print(a)
input()
# 1.第一步安装三个模块
# pip3 install pyqt5
# pip3 install pywin32
# pip3 install pyinstaller
# 2.写一段代码 .py结尾
# 生成一个文本 重命名 a.py
# 3.打开cmd 执行：pyinstaller -F C:\Users\ASUS\Desktop\a.py(文件路径)
# pyinstaller -F C:\Users\ASUS\Desktop\a.py
from openpyxl import Workbook wb = Workbook() # 先生成一个工作簿 wb1 = wb.create_sheet(‘index3‘,0) # 创建一个表单页 后面可以通过数字控制位置 wb2 = wb.create_sheet(‘index1‘) wb1.title = ‘login‘ # 后期可以通过表单页对象点title修改表单页名称 wb1["A1"] = "商品" wb1["B1"] = "价格" wb1["C1"] = "详情" wb1[‘A2‘] = "苹果" wb1[‘B2‘] = 50 wb1[‘C2‘] = "水果" wb1[‘A3‘] = "橘子" wb1[‘B3‘] = 20 wb1[‘C3‘] = "水果" # wb1.cell(row=6,column=3,value=88888888) #6行3列插入888888 # wb1[‘A5‘] = ‘=sum(A3:A4)‘ wb.save(‘test.xlsx‘)
原文：https://www.cnblogs.com/wukai66/p/12602022.html