Data Streamer Excel Add-ins: Read Temperature and Humidity in Ms.Excel from Arduino Uno
Vložit
- čas přidán 12. 10. 2023
- Read Humidity and Temperature in Excel from Arduino DHT-11 sensor using Data Streamer Add-ins
Data Streamer is a two-way data transfer for Excel that streams live data from a microcontroller into Excel, and sends data from Excel back to the microcontroller. To get data from a sensor into an Excel workbook, connect the sensor to a microcontroller that is connected to a Windows 10 PC or Windows 11 PC
DHT-11 Arduino Code: drive.google.com/file/d/1c-L-...
If you find this video helpful, please consider sending a Super Thanks as a form of support to this channel.
Thank you. - Jak na to + styl
THANK YOU SO MUCH!!!
is there any way to change the time or pace of collecting the data, for instance to collect weight data in a minute by minute basis?? thank you so much master!
You can change the interval of sending data in minute I think
Great tutorial! I get no data when I press Start data. The Arduino is connected and I have changed the baud to be the same as for my sensor
Did you follow the steps?
and how baout Serial.Print syntax on your code?
please follow the video about the format of serial print command
If I use 2 or more devices, can the data be displayed on the datastreamer?
I don't have experience using multi devices connected.
I don't know the result, but you can try it😉
Sir, how can I connect on data streamer, cuz only can connect one COM each time, so if I use arduino IDE to run my code, there is no way to connect the data streamer.
Yes, 1 Com cant used more than 1 application.
Everything worked perfectly for me except it’s not graphing properly
hi. thank you so much!!! is there anyway i can save the data with the timestamp?
You can send the timestamp from Arduino, you can use RTC module.
If you use ESP with wifi, you can use NTP to get time
@@YaserAliHusen im new to this. I will try based on advise. Thanks! Btw, can you do a tutorial on how to make esp32 accessible remotely without the same ssid?
@@andreatia21 If you just want to control LED on ESP with same network, you can use webserver.
I have a video about it, find with keyword ESP01
@@YaserAliHusen thanks a lot
Can we send HEX from excel to Arduino?
Maybe you can convert in arduino the received serial data
Is there a way to include dates?
You must put date in serial data.
For getting datetime, you can use ntp or another methods
When I select connect a device in excel sheet it shows unable to connect the device because it is used by another application
Maybe You still use Arduino IDE and connect serial monitor, close Arduino IDE first
Don't use serial monitor or serial plotter in the Arduino IDE
i can't connect my Arduino uno to data streamer when i press on connect to my device nothing happens and no error comes out
Did computer detect your uno?
And dont use serial monitor in arduino ide
@@YaserAliHusen yes computer can detect it and it works just fine in arduino ide, but when i close it and open data streamer it can't connect
@@xc4v866
There is no error notification?
How about Start Data?
@@YaserAliHusen its not available since no connection was established
0:29 how to add that data streamer file in excel ....plz tell that bro....i can't do that.... I'm very stressed about my project....team mates are not helping for me😢...as a single man... doing all things
What do you mean?addin data streamer adds on?
Foolow the video, right click on File Ribbon, then select Customize the Ribbon
@@YaserAliHusen bro in 0:29 ....that " Microsoft data streamer for excel" option is not exist in my excel
@@tamilpayan9093 If you don't see an entry for the Data Streamer add-in in the COM Add-Ins dialog box, it's because either your version of Office or Excel doesn't include it, or your organization's system administrator has made it unavailable
Ref: answers.microsoft.com/en-us/msoffice/forum/all/msexceldont-find-microsoft-data-streamer-on-add/8747a856-ad00-48a7-b4ef-888dee07e5a3