from openpyxl import load_workbook
从Excel读取数据
wb = load_workbook('文件名.xlsx') ws = wb.active
变量初始化
row_num = 0
创建一个新的Excel
wb_new = Workbook() ws_new = wb_new.active
遍历每一行
for row in ws.iter_rows(min_row=1, max_row=ws.max_row): cell_list = [] # 遍历每一列,跳过空单元格 for cell in ro