import openpyxl
# openpyxl 必须得是.xlsx文件后缀
book = openpyxl.load_workbook('test2.xlsx')

sheet = book['sheet1']
# print(book.sheetnames)  # 所有sheet页的名字
# print(sheet.rows)   # 所有行
for row in sheet.rows:  # 获取每行的数据
    row_data = [col.value for col in row]
    print(row_data)


# print(sheet.max_row)    # 最大行
# print(sheet.max_column) # 最大列
print(sheet.cell(1,1).value)    # 获取excel数据
# print(sheet["A1"].value)

# sheet["A1"] = "编号"  # 修改excel数据
# sheet.cell(1,1).value = "id"  # 修改excel数据
# book.save('test2.xlsx')