Draw images or play image sequences in excel by changing cell colors
- Python 3.3+
- Pillow
- Excel (tested on 2016 and 365)
By default, the file animation.xlsm contains the macros and data required to run the Chika dance animation. This can be run by opening the file in Excel, enabling macros, and running the macro: FillVideo.
This software isn't intended to be a practical soultion to any problem. Its just fun.
An image sequence should be made up of a directory of .png images with the file name NAME#.png where NAME can be specified and # should increment from 0 to n.
Resize the image sequence using ImageSeqResizer.py:
./ImageSeqResizer.py FILE_NAME DIRECTORY_PATH OUTPUT_PATH NEW_WIDTH NEW_HEIGHT
Convert the image sequence to a .csv file using ImageSeq2CSV.py:
./ImageSeq2CSV.py FILE_NAME DIRECTORY_PATH OUTPUT_FILE.CSV
This .csv file can be opened with excel. Copy the data from this file into animation.xlsm, overwriting the data in the CodeOutput sheet (macros need to be enabled). Alternatively, without using animation.xlsm, a new excel file can be generated using the code in VBACode.vba as a macro, this should have two sheets: Canvas and CodeOutput.
Run the macro FillVideo to view the animation.
Single images can also be displayed using Image2CSV.py to generate the .csv file and the FillImage macro to display them:
./Image2CSV.py INPUT.PNG OUTPUT.CSV
The example project includes video assets taken from 8 Bit Chika Fujiwara Dance, which is adapted from the Original rotoscope.