Image to Excel Converter

A simple Python command-line application that converts an image file into an Excel (.xlsx) spreadsheet. It accomplishes this by taking blocks of pixels from the original image, calculating their average color, and setting the background color of the corresponding Excel cells to match, creating a pixel-art representation of the image.

Prerequisites

To run this script, you will need Python 3 installed on your system along with a couple of external libraries.

Environment Setup

Clone or download this repository (or just the convert.py script) to your local machine.

(Optional but recommended) Create a virtual environment:

python -m venv venv
source venv/bin/activate  # On Windows use: venv\Scripts\activate

Install dependencies: The script relies on Pillow for image processing and openpyxl for Excel generation. Install them using pip:
```
pip install Pillow openpyxl
```

Usage

You can use the script directly from the command line by passing the path to the image you want to convert as an argument.

Command Line Interface

python convert.py path/to/your/image.jpg

Example:

python convert.py profile_pic.png

Output: The script will process the image in 40x10 pixel blocks, calculate the average RGB values, and map them to Excel cells. It will then generate an Excel file in the same directory, using the original image's name (e.g., profile_pic.xlsx).

initiating...
started...
Processing file: profile_pic.png
exel file "profile_pic.xlsx" saved.

Using as a Module

You can also import the conversion function into your own Python scripts:

from convert import convert_to_xl

output_file = convert_to_xl("path/to/image.png")
print(f"Successfully generated: {output_file}")

How it works

The script divides the image into horizontal blocks of 40 pixels and vertical blocks of 10 pixels. It iterates through the 400 pixels in each block, calculates the average RGB color, converts that color to a Hex code, and applies it as a solid fill to the corresponding cell in the generated .xlsx file.