| from openpyxl import load_workbook | |
| from openpyxl.drawing.image import Image | |
| def read_images_from_excel(file_path, filter_column): | |
| # Load the workbook | |
| wb = load_workbook(filename=file_path) | |
| # Iterate through each sheet in the workbook | |
| for sheet_name in wb.sheetnames: | |
| sheet = wb[sheet_name] | |
| # Find the column index of the filter column | |
| filter_column_index = None | |
| for col in range(1, sheet.max_column + 1): | |
| if sheet.cell(row=1, column=col).value == filter_column: | |
| filter_column_index = col | |
| break | |
| if filter_column_index is None: | |
| print(f"Filter column '{filter_column}' not found in sheet '{sheet_name}'") | |
| continue | |
| # Iterate through each row in the sheet | |
| for row in range(2, sheet.max_row + 1): | |
| # Check if the filter condition is met | |
| if sheet.cell(row=row, column=filter_column_index).value == "your_filter_value": | |
| # Iterate through each image in the row | |
| for image in sheet._images: | |
| # Check if the image is in the same row as the filter condition | |
| if image.anchor._from.row == row: | |
| # Get the image data | |
| img_data = image.image | |
| # You can process the image data here | |
| # For example, you can save the image to a file | |
| img_data.save(f"{sheet_name}_{row}_{image.anchor._from.col}.png") | |
| # Example usage: | |
| read_images_from_excel("example.xlsx", "Column F") | |