python 读写excel xlsx格式

我用的是openpyxl，用来处理xlsx格式的文件

官网地址：https://openpyxl.readthedocs.io/en/stable/tutorial.html#loading-from-a-file

from openpyxl import load_workbook

workbook = load_workbook('auto_size.xlsx')
sheet = workbook['Sheet1']  # 处理Sheet1
print sheet
d = sheet.cell(row=2, column=2) # 该页第二行第二列
d.value = 1  # 赋值为1
workbook.save('auto_size.xlsx')
print("xls格式表格写入数据成功！")