如何从流式excel表格解析到python pandas df？

import pandas as pd
import openpyxl
from openpyxl import load_workbook

df = pd.DataFrame()

wb = load_workbook(filename='your_file.xlsx', read_only=True)

sheets = wb.sheetnames

for sheet_name in sheets:
    sheet = wb[sheet_name]
    data = sheet.values
    cols = next(data)[1:]  # 获取列名，假设第一行为列名
    data = list(data)
    rows = []
    for row in data:
        rows.append(row[1:])  # 假设第一列为索引列
    temp_df = pd.DataFrame(rows, columns=cols)
    df = pd.concat([df, temp_df], ignore_index=True)

wb.close()