Python创建修改写入execl

Python操作Execl

openpyxl模块

pip install openpyxl -i https://pypi.tuna.tsinghua.edu.cn/simple

1. 创建execl文件

import openpyxl
from openpyxl import Workbook
​
# 创建execl文件
wb = openpyxl.Workbook()
ws = wb.create_sheet("读", 0)
wb.save("读写.xlsx")

2. 加载execl文件，修改sheet名字

 

# 修改sheet名字 写入数据
from openpyxl import load_workbook
​
wb = load_workbook("读写.xlsx")   # 加载execl文件
sheet2 = wb['Sheet2']       # 加载sheet2表格
sheet2.title = "写"          # 修改名字
sheet2['A1'].value = "哈哈"   
wb.save('读写.xlsx')

 

3. 循环写入数据

# 循环写入值
wb2 = load_workbook('读写.xlsx')
sheet2 = wb2['写']
​
for i in range(1, 11):
    sheet2['A{}'.format(i)].value = i
    
for j in range(1, 11):
    sheet2.cell(row=11, column=j, value=j)

wb2.save('读写.xlsx')