python学习-openpyxl模块
使用openpyxl创建表
from openpyxl import Workbook
import time
book = Workbook()
sheet = book.active
sheet['A1'] = 56
sheet['A2'] = 43
now = time.strftime("%x")
sheet['A3'] = now
book.save("sample.xlsx")
实现效果
路径:
C:/Users/Administrator/PycharmProjects/pythonProject


指定其他路径
book.save("C:\\Users\\Administrator\\Desktop\\sample.xlsx")

