▐▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▌
▐***██╗███╗***███╗*██████╗*****██████╗*****███████╗██╗**██╗███████╗██╗*****▌
▐***██║████╗*████║██╔════╝*****╚════██╗****██╔════╝╚██╗██╔╝██╔════╝██║*****▌
▐***██║██╔████╔██║██║**███╗*****█████╔╝****█████╗***╚███╔╝*█████╗**██║*****▌
▐***██║██║╚██╔╝██║██║***██║****██╔═══╝*****██╔══╝***██╔██╗*██╔══╝**██║*****▌
▐***██║██║*╚═╝*██║╚██████╔╝****███████╗****███████╗██╔╝*██╗███████╗███████╗▌
▐***╚═╝╚═╝*****╚═╝*╚═════╝*****╚══════╝****╚══════╝╚═╝**╚═╝╚══════╝╚══════╝▌
▐▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▌
        

Image2Excel Introduction

Overview

Image2Excel automates finding and organizing product images, exporting results to Excel. Runs on Windows; untested on Linux/other platforms.

Key Features

• Searches for images (png/jpg/jpeg) by product codes and suffixes (e.g., product_code-01.jpg), copies to Image2Excel_Export.
• Generates Excel file (output_date_time.xlsx) with product codes and images from cell A2.

Inputs

• Directory with images (local/SMB Shared).
• Input file (txt/xlsx, local/SMB Shared) with product codes (one per line).
• Up to four search suffixes (e.g., 01, 06).

Outputs

• Image2Excel_Export directory with matched images.
• Excel file with product codes and images.

Example Excel output:

A	B	C
abc0123	abc012-01.jpg	abc012-06.jpg
abc456	abc456-01.jpg	abc456-06.jpg

Step-by-Step User Guide

1. Launch Application: Run Image2Excel.exe on Windows. GUI loads settings from %APPDATA%\Image2Excel\settings.json.
2. Select Inputs:
   • Product List: Click "…" or "File" > "Open Product List" to select txt/xlsx with product codes.
   • Image Folder: Click "…" or "File" > "Select Image Folder" for image directory.
   • Output Folder: Click "…" or "File" > "Select Output Folder" for export location.
3. Enter Suffixes: Input up to four suffixes (e.g., 01, 06) in "Image Suffixes" fields.
4. Run Process: Click "Run" (Ctrl+R). Validates inputs, searches images, copies to Image2Excel_Export, creates Excel file, shows progress/logs.
5. Manage Process:
   • Pause: Click "Pause" (Ctrl+P).
   • Resume: Click "Resume" (Ctrl+O).
   • Stop: Click "Stop" (Ctrl+S).
6. Filter Logs: Use "Filter" dropdown: All, OK, Missing Images, Errors.
7. Save Settings: Paths/suffixes auto-saved to settings.json on change/run.
8. View Output: "File" > "Open Export Folder" to access images/Excel.
9. Switch Themes: "View" > "Light Mode" or "Dark Mode".
10. Access Help: "Help" > "About" for version/developer info.

View Source

View Source on GitHub