读取excel 单元格 value 的两种方式
wb = openpyxl.load_workbook(xlsx_path)
sheet = wb.active
print(sheet.max_row, sheet.max_column)
for i in range(1, 3):
# for j in range(1, sheet.max_column + 1):
# print(sheet.cell(row=i, column=j).value)
value = sheet['A1'].value
print(value)
非常好的参考网站 openpyxl 图文并茂
https://www.javatpoint.com/python-openpyxl
from openpyxl import load_workbook
wb = load_workbook('sample_book.xltx')
ws = wb.active
ws['D2'] = 42
wb.save('sample_book.xlsx')