如何使用python类打开不同的excel工作表

pip install openpyxl

from openpyxl import load_workbook

class ExcelReader:
    def __init__(self, file_path):
        self.file_path = file_path
        self.workbook = load_workbook(file_path)
    
    def get_sheet_names(self):
        return self.workbook.sheetnames
    
    def read_sheet(self, sheet_name):
        sheet = self.workbook[sheet_name]
        data = []
        for row in sheet.iter_rows(values_only=True):
            data.append(row)
        return data

# 示例用法
reader = ExcelReader('path/to/excel_file.xlsx')
sheet_names = reader.get_sheet_names()
print("Sheet Names:", sheet_names)

for sheet_name in sheet_names:
    data = reader.read_sheet(sheet_name)
    print("Data from", sheet_name)
    for row in data:
        print(row)