Send Data from Excel to Arduino Using Data Streamer

Explains with an example how to send data from Microsoft Excel to an Arduino using the Excel Data Streamer functionality

00:00 Introduction (Question from Alex)
00:20 Arduino Code
01:35 Test with Arduino Serial Monitor
01:56 Configure Data Streamer in Excel
02:23 Connect to Arduino
02:33 Check Baud Rate
02:45 Send data to Arduino from Excel
03:16 Control from another worksheet
03:43 Use Checkbox control to control Arduino LED
04:15 Control Arduino with C# application (Video by 50 Hz)

Link to code on github

[Hz]

That's epic mate, and thanks for the shout out much appreciated.

I can see this being very useful in a laboratory for automation of tests

[wesm]

This was fantastic. I was surprised to find someone who clearly explained everything and got me to the solution real quick. Much appreciated!

[anbroic]

Thanks for a great video. One question is it possible to stop the data streamer continuously streaming. I just want excel to log when a sensor is on and off when activated etc with time stamp.

[kevbot]

Is there a way to control which channel the commands go out on? I'm trying to use a single board to pull in sensor data and control a servo. Separately, these functions work perfectly, but when they're both happening simultaneously, it seems like data in and data out is both riding on channel 1, so the commands are only sometimes received.

[MrDotManPeriod]

i dont get the microsoft data streamer addins option, i get 3 options which are Acrobat PDFMaker then the Microsoft power map and Microsoft power pivot, can u help me

[amirailyanie]

what if i want to call the excel data in the void loop coding sir?

[atube]

엑셀data streamer에 단위가 800이 나왔다면 이것의 단위는 무엇일까요? 아두이노우노보드 10킬로센서에 10k옴 설치된 것입니다 감사합니다

If the Excel data streamer had 800 units, what would it be? Arduino Uno Board 10kg sensor with 10k ohms installed Thank you.

[jaysondelacruz]

How to do it the other way? Send data from arduino to Excel? Thank you in advance

[shirayokidono]

how can I change the condition instead of the letter t for example make it if a value > 1000

[vipinpachouri]

How to read numeric data of multiple rows and columns from Excel to Arduino

[nourhouddaezzahi]

This was good and great. I want to ask you how can I control a table in the data streamer I mean in sheet 1 I can control each statement in a box and use an array with 2 dimensions in code Arduino.

[Aghil-pwbu]

Thanks for a great video...I want to write numbers in two columns in Excel and save them in the sd card... In Arduino, first the condition that the written number is equal to which number in the first column and if the condition is true, it will show the opposite number that is in the second column...can you help me?

[omartarek]

Can I save the formatting on the data in and data out sheet because every time I connect the Arduino it resets it

[rimenaouissaoui]

Thank you for the video👍
I wonder if it is possible to send the data to the Arduino automatically and not enter it manually in Excel. I want to control a servo with Arduino. the angle at which the motor has to turn is stored in a text file (every 10 minutes an angle value is stored in the txt file and the old value is deleted). I need to write a program that constantly accesses the text file, reads angles and automatically sends the value to the Arduino.
the idea is that, the text file will be imported by macro or a vba code into excel, the angle value will be sorted and stored in variable then this value must be stored in a cells in the Output sheet. is that possible?

[amgedgamer]

Can you make a video save excel in SD card and show this data in the lcd ????.
For example show every day note that already saved all note in the excel tn sd card

[jithuiv]

Thank you for sharing your knowledge. It really helped me 🙏

[spiderbloke]

This was so great! Thanks for explaining it in a clear way.

[Aghil-pwbu]

Hello, I am new and I could not achieve my goal with the previous instructions
My ultimate goal:
I want to create a table in Excel and save it in the sd card which contains three columns.. The first column is longitude and the second column is latitude and the third column is a number between 0 and 10... then We receive GPS input, and if the longitude and latitude were equal to each of the numbers we wrote in the first column and the second column, it will display one of the numbers (0 to 10) on the serial monitor... Your help is very important to me.

[stevedennis]

is the arduino code available somewhere?

[AmritTN]

Hey can we use it for daynamic data?


Good work 👍