python学习-openpyxl模块

cherish the present / 2023-07-21 / 原文

使用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")