Excel for WS2812 RGB LED Array Animations

An Excel Application generates text code for copy/paste into a purpose built sketch to create various forms of animation.

Nov 20, 2021

13021 views

3 respects

Components and supplies

1

9V to Barrel Jack Connector

1

Arduino UNO

1

Male-Header 5 Position- 1 Row- Long (0.1")

3

Male/Female Jumper Wires

1

9V battery (generic)

1

ws2812 8x8 RGB LED matrix

Tools and machines

1

Solder Wire, Lead Free

1

Soldering iron (generic)

Project description

Code

LED_Arduino

c_cpp

This sketch forms the foundation of the project. On saving it should be set to Read-Only and further usage to be as 'Save As' for archiving to prevent overwriting and allow easy reedit.

Sketches.zip

These are some of or more sketches used during development. They are available as 'support'.

LED_Arduino

c_cpp

This sketch forms the foundation of the project. On saving it should be set to Read-Only and further usage to be as 'Save As' for archiving to prevent overwriting and allow easy reedit.

Sketches.zip

These are some of or more sketches used during development. They are available as 'support'.

Led_Utility.xlsm

This application generates the various text for copy/paste into the sketch.

Comments

Only logged in users can leave comments

billz1

8 months ago

When testing any of your examples, I get the following errors in the current Arduino IDE (see below). What changes to your program example do you suggest to get a working program? I can't see the 'garbage at end of line' that the IDE is referring to. Arduino: 1.8.13 (Windows 10), Board: "Arduino Mega or Mega 2560, ATmega2560 (Mega 2560)" C:\Program Files (x86)\Arduino\arduino-builder -dump-prefs -logger=machine -hardware C:\Program Files (x86)\Arduino\hardware -hardware C:\Users\bill\AppData\Local\Arduino15\packages -hardware C:\Users\bill\Documents\Arduino\hardware -tools C:\Program Files (x86)\Arduino\tools-builder -tools C:\Program Files (x86)\Arduino\hardware\tools\avr -tools C:\Users\bill\AppData\Local\Arduino15\packages -built-in-libraries C:\Program Files (x86)\Arduino\libraries -libraries C:\Users\bill\Documents\Arduino\libraries -fqbn=arduino:avr:mega:cpu=atmega2560 -ide-version=10813 -build-path C:\Users\bill\AppData\Local\Temp\arduino_build_876953 -warnings=none -build-cache C:\Users\bill\AppData\Local\Temp\arduino_cache_981259 -prefs=build.warn_data_percentage=75 -prefs=runtime.tools.avr-gcc.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avr-gcc\7.3.0-atmel3.6.1-arduino7 -prefs=runtime.tools.avr-gcc-7.3.0-atmel3.6.1-arduino7.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avr-gcc\7.3.0-atmel3.6.1-arduino7 -prefs=runtime.tools.avrdude.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avrdude\6.3.0-arduino17 -prefs=runtime.tools.avrdude-6.3.0-arduino17.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avrdude\6.3.0-arduino17 -prefs=runtime.tools.arduinoOTA.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\arduinoOTA\1.3.0 -prefs=runtime.tools.arduinoOTA-1.3.0.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\arduinoOTA\1.3.0 -verbose C:\Users\bill\AppData\Local\Temp\arduino_modified_sketch_319046\sketch_mar25a.ino C:\Program Files (x86)\Arduino\arduino-builder -compile -logger=machine -hardware C:\Program Files (x86)\Arduino\hardware -hardware C:\Users\bill\AppData\Local\Arduino15\packages -hardware C:\Users\bill\Documents\Arduino\hardware -tools C:\Program Files (x86)\Arduino\tools-builder -tools C:\Program Files (x86)\Arduino\hardware\tools\avr -tools C:\Users\bill\AppData\Local\Arduino15\packages -built-in-libraries C:\Program Files (x86)\Arduino\libraries -libraries C:\Users\bill\Documents\Arduino\libraries -fqbn=arduino:avr:mega:cpu=atmega2560 -ide-version=10813 -build-path C:\Users\bill\AppData\Local\Temp\arduino_build_876953 -warnings=none -build-cache C:\Users\bill\AppData\Local\Temp\arduino_cache_981259 -prefs=build.warn_data_percentage=75 -prefs=runtime.tools.avr-gcc.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avr-gcc\7.3.0-atmel3.6.1-arduino7 -prefs=runtime.tools.avr-gcc-7.3.0-atmel3.6.1-arduino7.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avr-gcc\7.3.0-atmel3.6.1-arduino7 -prefs=runtime.tools.avrdude.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avrdude\6.3.0-arduino17 -prefs=runtime.tools.avrdude-6.3.0-arduino17.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avrdude\6.3.0-arduino17 -prefs=runtime.tools.arduinoOTA.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\arduinoOTA\1.3.0 -prefs=runtime.tools.arduinoOTA-1.3.0.path=C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\arduinoOTA\1.3.0 -verbose C:\Users\bill\AppData\Local\Temp\arduino_modified_sketch_319046\sketch_mar25a.ino Using board 'mega' from platform in folder: C:\Users\bill\AppData\Local\Arduino15\packages\arduino\hardware\avr\1.8.6 Using core 'arduino' from platform in folder: C:\Users\bill\AppData\Local\Arduino15\packages\arduino\hardware\avr\1.8.6 Warning: Board Breadboard:breadboard:atmega328bb doesn't define a 'build.board' preference. Auto-set to: BREADBOARD_ATMEGA328BB Detecting libraries used... "C:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\tools\\avr-gcc\\7.3.0-atmel3.6.1-arduino7/bin/avr-g++" -c -g -Os -w -std=gnu++11 -fpermissive -fno-exceptions -ffunction-sections -fdata-sections -fno-threadsafe-statics -Wno-error=narrowing -flto -w -x c++ -E -CC -mmcu=atmega2560 -DF_CPU=16000000L -DARDUINO=10813 -DARDUINO_AVR_MEGA2560 -DARDUINO_ARCH_AVR "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\cores\\arduino" "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\variants\\mega" "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\sketch\\sketch_mar25a.ino.cpp" -o nul -DARDUINO_LIB_DISCOVERY_PHASE Generating function prototypes... "C:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\tools\\avr-gcc\\7.3.0-atmel3.6.1-arduino7/bin/avr-g++" -c -g -Os -w -std=gnu++11 -fpermissive -fno-exceptions -ffunction-sections -fdata-sections -fno-threadsafe-statics -Wno-error=narrowing -flto -w -x c++ -E -CC -mmcu=atmega2560 -DF_CPU=16000000L -DARDUINO=10813 -DARDUINO_AVR_MEGA2560 -DARDUINO_ARCH_AVR "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\cores\\arduino" "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\variants\\mega" "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\sketch\\sketch_mar25a.ino.cpp" -o "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\preproc\\ctags_target_for_gcc_minus_e.cpp" -DARDUINO_LIB_DISCOVERY_PHASE "C:\\Program Files (x86)\\Arduino\\tools-builder\\ctags\\5.8-arduino11/ctags" -u --language-force=c++ -f - --c++-kinds=svpf --fields=KSTtzns --line-directives "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\preproc\\ctags_target_for_gcc_minus_e.cpp" Compiling sketch... "C:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\tools\\avr-gcc\\7.3.0-atmel3.6.1-arduino7/bin/avr-g++" -c -g -Os -w -std=gnu++11 -fpermissive -fno-exceptions -ffunction-sections -fdata-sections -fno-threadsafe-statics -Wno-error=narrowing -MMD -flto -mmcu=atmega2560 -DF_CPU=16000000L -DARDUINO=10813 -DARDUINO_AVR_MEGA2560 -DARDUINO_ARCH_AVR "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\cores\\arduino" "-IC:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\hardware\\avr\\1.8.6\\variants\\mega" "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\sketch\\sketch_mar25a.ino.cpp" -o "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\sketch\\sketch_mar25a.ino.cpp.o" Compiling libraries... Compiling core... Using precompiled core: C:\Users\bill\AppData\Local\Temp\arduino_cache_981259\core\core_arduino_avr_mega_cpu_atmega2560_d9b30e61b49076c99692887f520bb462.a Linking everything together... "C:\\Users\\bill\\AppData\\Local\\Arduino15\\packages\\arduino\\tools\\avr-gcc\\7.3.0-atmel3.6.1-arduino7/bin/avr-gcc" -w -Os -g -flto -fuse-linker-plugin -Wl,--gc-sections -mmcu=atmega2560 -o "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953/sketch_mar25a.ino.elf" "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953\\sketch\\sketch_mar25a.ino.cpp.o" "C:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953/..\\arduino_cache_981259\\core\\core_arduino_avr_mega_cpu_atmega2560_d9b30e61b49076c99692887f520bb462.a" "-LC:\\Users\\bill\\AppData\\Local\\Temp\\arduino_build_876953" -lm C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s: Assembler messages: C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:53: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:61: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:76: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:84: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:99: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:107: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:121: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:129: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:144: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:152: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:167: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:175: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:189: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:197: Error: garbage at end of line C:\Users\bill\AppData\Local\Temp\ccSH6mAa.s:216: Error: garbage at end of line lto-wrapper.exe: fatal error: C:\Users\bill\AppData\Local\Arduino15\packages\arduino\tools\avr-gcc\7.3.0-atmel3.6.1-arduino7/bin/avr-gcc returned 1 exit status compilation terminated. c:/users/bill/appdata/local/arduino15/packages/arduino/tools/avr-gcc/7.3.0-atmel3.6.1-arduino7/bin/../lib/gcc/avr/7.3.0/../../../../avr/bin/ld.exe: error: lto-wrapper failed collect2.exe: error: ld returned 1 exit status exit status 1 Error compiling for board Arduino Mega or Mega 2560.