Spaces:
Sleeping
Sleeping
File size: 3,314 Bytes
bbf2a31 d5089aa bbf2a31 d5089aa bbf2a31 f05d877 0dc6fb4 f05d877 bbf2a31 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 | ---
title: Image Editor
emoji: 🐠
colorFrom: green
colorTo: indigo
sdk: gradio
sdk_version: 5.37.0
app_file: app.py
pinned: false
---
# ImageResizer
Batch download, resize, and export product images via a Gradio web UI. Designed for e-commerce catalog workflows where image URLs live in Excel workbooks.
## Run locally
```bash
pip install -r requirements.txt
python app.py
```
Or install as a package:
```bash
pip install -e .
python app.py
```
## Project layout
```
ImageResizer/
├── app.py # Hugging Face Spaces entry point
├── Template.xlsm # Workbook template (download from UI in workbook mode)
├── image_resizer/
│ ├── config.py # Constants and settings
│ ├── models.py # Shared types (ImageItem, ProcessResult)
│ ├── failure_log.py # Failed download logging
│ ├── downloader.py # HTTP / cloudscraper / Selenium downloads
│ ├── image_ops.py # Resize, format conversion, save
│ ├── pipeline.py # Download + process + ZIP orchestration
│ ├── workbook.py # Excel workbook parsing
│ ├── processor.py # High-level processing (no UI)
│ └── ui/
│ ├── theme.py # CSS and HTML assets
│ ├── handlers.py # Gradio event handlers
│ └── demo.py # build_demo() — Gradio Blocks assembly
├── requirements.txt
└── pyproject.toml
```
## Input modes
- **Upload Workbook** — Parse `.xlsx`/`.xlsm` files with an `ItemCode` column and URL/image/link columns. Use **Download Template** beside the upload field to get `Template.xlsm` from the project root.
- **Upload Images** — Process local image files or a single pasted URL
## Workbook template
Place `Template.xlsm` at the repository root. The app serves it via the **Download Template** button in workbook mode. Commit this file to git so Hugging Face Spaces can serve it.
### Clear Data button (Cleared Data sheet)
`ClearClearedData.bas` provides **Clear Data** for the Cleared Data worksheet (clears B2 onward; keeps row 1 and column A).
1. Import `ClearClearedData.bas`.
2. Run macro `CreateClearDataButton` once, **or** add a Form Control button on Cleared Data assigned to `ClearClearedDataSheet`.
3. Clicking the button asks for confirmation, then clears data contents only (no row/column/format deletion).
### Amazon URL auto-cleaner (Excel VBA)
`AmazonUrlCleaner.bas` strips Amazon image size modifiers (e.g. `._AC_SL1500_`) automatically when URLs are typed or pasted.
**Scope:** Manual and WriteBuffer sheets only, cells from B2 onward (never row 1 or column A).
**Install into `Template.xlsm`:**
1. Open the workbook → Alt+F11.
2. File → Import File → select `AmazonUrlCleaner.bas` only.
3. Open **ThisWorkbook** (do not import the txt file). Paste the `Workbook_SheetChange` procedure from `AmazonUrlCleaner_ThisWorkbook.txt`.
4. Debug → Compile VBAProject, then save as `.xlsm`.
## Hugging Face Spaces
This repo is configured for [Hugging Face Spaces](https://huggingface.co/docs/hub/spaces-config-reference). The Space uses root `app.py` as the entry point.
Check out the configuration reference at https://huggingface.co/docs/hub/spaces-config-reference
|