Convert image to Excel file

img2xlsx.py

import xlsxwriter
from PIL import Image
import sys


def rgb2hex(r, g, b):
    return '#{:02x}{:02x}{:02x}'.format(r, g, b)


if len(sys.argv) != 3:
    print(sys.argv[0] + ' place.png place.xlsx')
    exit()

im = Image.open(sys.argv[1])
px = im.load()
wb = xlsxwriter.Workbook(sys.argv[2])
ws = wb.add_worksheet()
fmts = {}

for y in range(0, im.height):
    for x in range(0, im.width):
        r, g, b, _ = px[x, y]
        c = rgb2hex(r, g, b)
        if c in fmts:
            f = fmts[c]
        else:
            f = wb.add_format()
            f.set_bg_color(c)
            if r + g + b < 128 * 3:
                f.set_font_color('white')
            fmts[c] = f
        ws.write(y + 1, x + 1, ' ', f)

wb.close()
print('Done.')

requirements.txt

Pillow
XlsxWriter