【openpyxl】读取数据

• 1.excel数据
  
• 2.读取成列表包裹字典的格式
  
• 3.代码

import openpyxl

def read_excel_rows(file_path, sheet_name=None, start_row=2, end_row=None):
    wb = openpyxl.load_workbook(file_path)
    sheet = wb[sheet_name] if sheet_name else wb.active

    # 若未指定end_row，则读取到最大行
    max_row = sheet.max_row if end_row is None else end_row

    # 读取表头（假设第一行为表头）
    headers = [cell.value for cell in sheet[1]]

    # 收集数据行
    data = []
    for row in sheet.iter_rows(min_row=start_row, max_row=max_row):
        row_dict = {headers[i]: cell.value for i, cell in enumerate(row)}
        data.append(row_dict)

    return data

# 使用示例
rows_data = read_excel_rows("xuexi001.xlsx", start_row=2)
for row in rows_data:
    print(row)