Send Data from Excel to Arduino Using Data Streamer
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- 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)
• Control Arduino - wi...
This was fantastic. I was surprised to find someone who clearly explained everything and got me to the solution real quick. Much appreciated!
Thanks. Glad it helped.
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
Thanks and you are welcome.
This was so great! Thanks for explaining it in a clear way.
Glad to help.
This needs more views!
Thanks
Thank you for sharing your knowledge. It really helped me 🙏
I am glad it helped.
Thank you this was really helpfull!!!
Thanks for the comment. I am glad the video helped.
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.
One way would be to use the first cell of the dataout table as a row index and put some code on the Arduino side to read that index and put the rest of the cell data into your array. You could use vlookup to another table and then count up through the rows.
Hope this makes sense.
I might try to do a video about it.
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.
Hi David. Yes you can. I assume you are talking about data coming into excel? The following video has an example of Arduino sending a number of entries to Excel (200 from memory) when I push the button on the Arduino. Excel is listening the whole time but only shows receives a new entry each time the Arduino sends a reading. In your case just have your device send a single message when the sensor switches on or off.
Video link to example: th-cam.com/video/YC7DVCxCyXE/w-d-xo.html
@@overengineeredinoz7683 Thanks for the quick reply. That’s great. I will try that. This will be my first time using Arduino. Is your code available?
github.com/OverEngineeredInOz/TH-cam/
has code from the videos
@@overengineeredinoz7683 Thanks for your help 😊
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.
normally there is 10 channels in the excel datain and dataout sheets. perhaps use ch1 for in and ch2 for out and maybe just have the arduino echo back the last thing it has received on channel 1.
There is another video I have where it deconstructs the comma separated list that may be useful to you called:
How to control servos and LEDs using Excel Data Streamer and Arduino
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?
Hi
Yes you should be able to do that. Check out the video how to control servos and LEDs using excel on my channel. It has some examples and also links to code. That should help.
@@overengineeredinoz7683 thank you very much for the answer 🙏
@@Aghil-pw4bu you are welcome
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?
Yes it probably is possible. Great idea for another video thanks. I think I did a test in the past and if a cell is updated by VBA macro the data streamer function of excel still worked.
@@overengineeredinoz7683 thank you very much for the answer 🙏
please make the video as soon as possible haha. I need it😅
I have just posted the video.
th-cam.com/video/flN42_LTjKQ/w-d-xo.html
Hey can we use it for daynamic data?
Good work 👍
I am not sure what you mean by dynamic data?
@@overengineeredinoz7683 I'm want to integrate with live score on website
*I mean
Do you mean you want data from Arduino to appear on website or do you mean pull score data from website into excel?
@@overengineeredinoz7683 score from website to Excel
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
Check you are clicking 'com' addins. Does that help?
how can I change the condition instead of the letter t for example make it if a value > 1000
This video has an example where numbers are involved. th-cam.com/video/XYpZaPrbRWg/w-d-xo.html
Hope that helps
엑셀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.
I am sorry. I don't understand what you are asking.
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
I will have a look at doing a video with an lcd
@@overengineeredinoz7683
Ok thanks bro
Just published a video with excel sending to lcd attached to Arduino
How to read numeric data of multiple rows and columns from Excel to Arduino
For multiple columns of data it is sent comma separated. This video has an example
th-cam.com/video/AZCSoGNRO8s/w-d-xo.html
Can I save the formatting on the data in and data out sheet because every time I connect the Arduino it resets it
I don't think you can. I have encountered the same thing. What you can do as a workaround is use formulas on a another sheet to point to the data in sheet and format that sheet.
You can also have formulas in the data out sheet cells referring to formatted data in another worksheet.
Hope that helps.
@@overengineeredinoz7683 thanks alot I will give it a try
@@omartarek6658 you are welcome. Good luck.
what if i want to call the excel data in the void loop coding sir?
It is probably possible if you use both data streamer in and out features. I will think about doing that as a video.
Can we send a excel file as input
The video titled: Excel Macros with Data Streamer to control Arduino and Servos
may help with what you are trying to do.
How to do it the other way? Send data from arduino to Excel? Thank you in advance
I have an example of sending data from Arduino to Excel in the video titled:
Using Excel Data Streamer - Arduino Oscilloscope (Exceloscope part4: automation with data streamer)
is the arduino code available somewhere?
I have uploaded the code here.
github.com/OverEngineeredInOz/TH-cam/tree/master/Send%20Data%20From%20Excel%20to%20Arduino%20Using%20Data%20Streamer
@@overengineeredinoz7683 Thank you
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.
Hi. What part(s) are you stuck on.
Talking to the GPS?
Writing/reading to/from the SD card?
Getting excel data to the Arduino from excel?
Something else?
@@overengineeredinoz7683 The part of reading from the sd card, but after reading the data from the sd card, I want to compare that information with an input I get from the gps... I have no problem with the gps part, my problem is comparing the gps data and the sd card data
@@Aghil-pw4bu ok so you able to read the data from SD card but are having trouble with the comparison?
@@overengineeredinoz7683 Yes, exactly
@@Aghil-pw4bu apologies if you are already doing these things but hear are some suggestions.
1 the long and lat will need to be a number not a string to do the comparison so some sort of type conversion will need to be done.
2 an exact match is very unlikely. So rather than comparing for that you want to test if it is near the target point plus or minus some value.
Eg one test will be does lat fall within a range and does long also fall within a range.
Hope this helps.
Hi, Thank you for sharing that nice video! But I need your help. I try to reconstruct the code and failed. Then I copy paste your code from github and got the same issue. So there could not be any typo issue. The file does up load fine on my Mega 2560. But when I type anything in the serial monitor there is no reaction. Baudrate is correct. I found out that the Arduino does not enter the "if (incomingByte==10)" loop. I tried the same with your DataStreamerToLCD.ino, but got the same issue. I know it is difficult with remote/offline support but do you have any idea? I thank you in advance!
I did some more tests. Your code gives me the expected reaction when I type in 8xt in one command or 8 times t as a single command. The same with the LOW output. Do you have any idea about my issue?
It almost sounds like it is reading it backwards. I might be able to check on the weekend
@@overengineeredinoz7683 I would realy appreciate that. Thank you!👍
@@patrickmohs2387 Hi. I tried running up the code again on my Mega and it worked. I did notice it would fail if the serial monitor was not set to include a "newline" setting down the screen near the bottom right.
It doesn't sound like the issue you are having though.
If I read it correct you get the light comming on when you put tttttttt into the serial monitor.
If it is backwards for some reason you could try changing the code if (my_str[0] == 't') to instead be if (my_str[7] == 't') and see if that makes a difference.
if it doesn't work at all then check you at least get one of the rx/tx lights flashing on your mega when you do send from the serial monitor.
Not sure if any of the above will help but I am wishing you good luck.
@@overengineeredinoz7683 Hi! Now it is working. Awesome, thank you very much! The "newline" setting was the issue.