openpyxl 读写 excel

import openpyxl
book = openpyxl.load_workbook('b.xlsx') # 读取
# sheet = book["name_tab"]
sheet = book.active # 
row=sheet.max_row  # 行数
column=sheet.max_column # 列数
print(row)
print(column)
for r in range(2, row+1): # 跳过表头，行号是从1开始的，列号是从0开始的
	for c in range(14,24,2): # [14, 24) 之间每隔一列操作一下
		sheet[r][c].value = 1
book.save("b_.xlsx") # 保存

import openpyxl
import time
book = openpyxl.load_workbook("b.xlsx")
sheet = book.active
row=sheet.max_row
column=sheet.max_column
print(row)
print(column)

s_time = time.time()
for r in range(2, row+1): # 跳过表头
	for c in range(0, column):
		sheet[r][c].value = 1
e_time = time.time()
print(e_time - s_time)
book.save("b.xlsx")

s_time = time.time()
for r in range(2, row+1): # 跳过表头
	for c in range(0, column):
		sheet.cell(r,c+1).value = 2
e_time = time.time()
print(e_time - s_time)
book.save("b_.xlsx")

3063
33
735.839537858963
0.19450640678405762