根据条件筛选Excel文件中的数据

[python]代码库

import openpyxl

workbook = openpyxl.load_workbook('example.xlsx')
worksheet = workbook.active

# 根据条件筛选数据
filtered_data = []
for row in worksheet.iter_rows(min_row=1, max_row=worksheet.max_row, 
                                min_col=1, max_col=worksheet.max_column):
    if row[0].value == 'Apple':
        for cell in row:
            data = cell.value
            filtered_data.append(data)

print(filtered_data)