How to control servos and LEDs using Excel Data Streamer and Arduino

Demonstration of how to control hardware from Microsoft Excel using Arduino functions to parse the comma separated data. Learn how to use the Arduino: strtok, stroke, strcmp and atoi functions.
Learn about Excel Dec2Bin formula
00:00 Introduction
00:55 Example RGB Controller
01:10 PWM square wave generator with adjustable duty cycle
0:1:25 Scoreboard
01:49 Writing the Arduino Code
3:05 strtok to parse comma separated data into parameters
04:17 strtoke function (handles commas with nothing between them)
05:00 Binary counter code
05:28 strcmp (for comparing strings)
05:46 testing with serial monitor
06:05 LED control from Microsoft Excel
06:36 Dec2Bin excel function
06:50 Servo Control code
07:49 Atoi function to convert text to integer
8:15 Test Servo control
08:46 Excel Servo controller setup
09:13 Excel scroll bar to number linkage
Send Data from Excel to Arduino video link:

[joffrymohdjemi]

I wonder if can we communicate Excel Data Streamer to Adruino with WS2812 LED attached. A simple task, if I put number 2 in Cell A2, then 2nd LED will turn on.

[paulitojoseph]

Is there any way to import the table into the Arduino or something like that? In my project I want it to be something more remote, without the need for a computer.

[asaprocky]

Very nice lesson, but why must so many who instruct via a keyboard, have to SLAP THE CRAP OUT OF THE ENTER OR RETURN KEY? Tap, tap, tap, tap, BANG! Is it some sort of self projection thing?

[davelopez]

I'm new to arduino. In fact I have one ordered buy haven't received it yet.
My though is to use excel activex controls to control fan speed through the arduino.
In other words build a cheap labview interface (I don't have) using excel (which I already have.
It seems, using this method that it would be possible.
Just send out a serial string when a value, in excel, is changed.

But I ponder if using the computer's parallel interface wouldn't be more efficient.
(yup. I still have a computer with a parallel interface (aka printer port).
Assign each output pin (there's 8 total) on the parallel port to one of the control
channels.
BTW, I am already using parallel ports in this manner for other applications.
It means not having to shell out mucho dinero for labview I/O boards/software.

[sulastrianggraini]

Hi, i'm currently doing a project where I have a set of list in excel and i need it to link the code numbers in the list to the LED lights without the need of typing "TRUE" or "FALSE". Is this possible?

[reyrank]

This is really cool. can i ask your sample code for this for my plan project?

[aolremfor]

Can you zoom in a bit next time? Very hard to read the code. Thanks

[aryawezard]

Hi thanks for the great video, is it possible to connect an led screen that displays voltages and current to excel?
Whatever the values on the screen will show in excel?

[kojiroikeda]

Thanks for your series of videos that lead me to understand more about execl-arduino connection.
one question: can the data out sheet have more than 10chs? if we need to transfer more than 10 columns, what possibly can we do? thanks anyway.

[rajagopalrm]

I have done the process for the servo part but I couldn't find the same icon to connect the com port except that everything that you explained was crt and I got r8

Pls help me with it to found out the error to the connection between excel to arduino

If you provide your contact details like mail it would be helpful

[leonardocoutinhoazevedo]

Bom dia! I love your work! I want this sketch. Please!

[loddie]

Great video! Thank-you for sharing. What is the maximum number of output channels Excel will allow? The default in your video is 10, but microcontrollers such as the Arduino MEGA 2560 can handle many more. I'm curios if Excel has an output limit.

[ProjeAdam.]

Hello sir, Why I cant do this project with esp32 ?? ESP32 not answer

[dorianduda]

Hello, that is really great what have you done and show here. Is it possible to control from excel addressable LEDs WS2812B? The idea is to connect the Barcode or QR Code Scanner to the computer and depends on which barcode would be scanned then proper individual LED would light up?

[arseniyaikin]

Hi. Great video. I am using the servo control part of your code for my project. I was wondering if there is a way to control servo speed while keeping the same working principal?