我用的是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格式表格写入数据成功!")