Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and smarter.
The objective: to convert an image to cell art by adjusting background color
The Means: obviously VBA
The Solution: Of course someone already solved it, and it is none other than Andy Pope. Download the tool for converting BMP files to XY Scatter charts or cell art from his site. Once you have the file,
- Take any image you want to convert and open it in an image editor like Paint.NET or photoshop
- Reduce the number of colors in the image to 56
- Save the image as BMP
- Now go back to the downloaded file and open the VB Editor (Alt+F11)
- Open the form frmBMPLoader and hit F5 to run the form
- Specify the BMP file path to convert the image to cell art
- Once the processing is done, adjust zoom (to 10%) to see the entire image
What next? Now that you know a cool way to have some fun with excel, why not get serious and read some of the past posts on PHD 😛 ?
One Response to “Easily Convert JSON to Excel – Step by Step Tutorial”
Great guide! You mentioned that "Power Query in Excel offers a quick, easy and straightforward way to convert JSON to Excel." This is very true for simple structures. For those dealing with deeply nested JSON that Power Query struggles with, I've found a few tips helpful: 1) Flatten the JSON structure before importing if possible, 2) Use Python for more complex transformations as you suggested.