Please find the full program in the GitHub link below
https://github.com/FelixT123/CS-Student/tree/main/Openpyxl
Openpyxl is the most common library for Python to read/write Excel file. I spent half a day to familiar myself with how the library operates.
Below are a few snapshots when the program is running
Asked to type the file name of the PNG image file (In this case, stevejob). Then the background color of the cells change to match with pixels of the PNG image file.
At the end of the program, the corresponding Excel file will open on its own
May I present, the late great Steve Job!
Make sure to install the following libraries onto your device before running the program
pip install openpyxl
pip install Image
pip install pywin32