Arduino UNO R4 WiFi LED Matrix Animation Helper (Excel Tool)

Using Arduino LEDs and Multiplexing
1

Hi Everyone,

I just got an R4 WiFi and played with the LED matrix after firing it up yesterday.

I geeked out a lot on the ArduinoLEDMatrix.loadSequence method and I created an Excel Spreadsheet with VBA that builds animation code from frames "drawn" in the Excel sheet. In each drawn frame, entering a "1" turns the cell red (the actual LED color) and entering a "0" or blank in each cell leaves it white.

LED Animate
LED Animate1341×838 229 KB

I'm still working on it (perfecting it) but will share publicly once it's good enough.

Here's a couple of notes so far:
1.) It uses VBA (.xlsm) to update the code in real time (every time there is a change to any cell in the sheet).
2.) Copy->Paste from Excel to the Arduino IDE puts quotes around the whole code and additional quotes around "Arduino_LED_Matrix.h" (probably just going to live with that).

Best Regards,
Jordan Kerr

2

I've done somewhat similar things in Excel. It's generally possible to do this without using any VBA, which makes things a little easier to distribute. All it takes is a little creativity with existing excel functions.

3

Hi Rsmls - Yeah I might try for that later version or even before publishing (thought the same thing). It works now but still a bit to kludgy to share.

Cheers,
Jordan

4

Mind you,the VBA code may end up being easier to read and maintain than the function-based approach.

5

Hello everyone,
I also looked into this topic and posted a solution in Excel in the forum.

Take a look at the German forum under the topic 'arduino-uno-r4-wifi-matrix-bild-und-animation-erstellen'

The language can be changed to English...

Maybe it's what you have in mind or you can just use a few code snippets as inspiration for your project.

Greetings ewu