openpyxl操作Excel文件

案例数据

该数据生成请看 : https://blog.csdn.net/qq_52549196/article/details/126145651

遍历表

import openpyxl

read_xlsx = openpyxl.load_workbook('1.xlsx')   # 读取文件
readSheet1 = read_xlsx["Sheet1"]   # 选择 Sheet1


for row in range(1, readSheet1.max_row):  # 获得最大行
    print(*[readSheet1.cell(row, i).value for i in range(1, readSheet1.max_column)])  #获得最大列并遍历
1
2
3
4
5
6
7
8