# -*- coding: utf-8 -*-
# @Author: https://blog.csdn.net/bitquant
# @Date: 2017-08-26
import openpyxl
import time
wb = openpyxl.Workbook()
wb.save("test4.xlsx")
time.sleep(1)
sheet = wb.active
sheet.cell(row=1, column=1, value=1234)
sheet.title = '系统配置'
sheet = wb.create_sheet(title="Mysheet1")
for r in range(1, 3 + 1):
for c in range(1, 4 + 1):
print("row:%s \tcolumn:%s" % (r, c))
sheet.cell(row=r, column=c, value=r * 10 + c)
wb.save("test4.xlsx")
sheet = wb.create_sheet("Mysheet2")
for i in range(10, 14):
for j in range(10, 15):
sheet.cell(row=i, column=j, value=i * 10 + j)
wb.save("test4.xlsx")
使用Python操作读写Excel
最新推荐文章于 2024-05-16 11:06:33 发布