| 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") |
|
|
