Arduino to excel Communication ✔
ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- Software Link : www.parallax.c...
Arduino code: fedgety.blogsp...
FOLLOW ME:
Facebook: / karimmufte
Instagram: / karimmufte
LinkIn: / mahamudul-karim-khonda...
Twitter: / karimmufte
TH-cam: / mahamudulkarimkhondaker
Seen many videos but your video is very straightforward. Very helpful.
Thank you, please keep connect
Thank you so much about this video. It just solved my problem.
I think you did a great job! Got my first Uno today and this project was perfect for next level of blink :)
Many Many Thanks from Bangladesh
you are most welcome
Thank you this was very helpful.
So glad!
It's really helping me figure out and learn about these!
i got an error --> could not load an object, because it is not available on this system
Excellent only one aclaration you need office 2010. Because with one more recent version doesn't work
Thanks sir ! very helpful for me
I get all the correct indications but no data on excel. The POP up screen shows the system is communicating and the "R" red light is flashing and it says it's connected.
nice video...........
thanks
Thanks, very much
Welcome 🥰
Is possible vice versa; sending from the Excel to Arduino... delay time, step's for one motor, change the temperature level from excel data sheet or watering time base the humidity reader.?
It is almost the same. You can try it by applying vice versa.
@@DefiningMoment I will try ... next week that I will back. THAT'S COOL
@@rafaelreina6364 yes that great 👍
thanks for sharing. A very useful tutorial.
You are welcome!
This is really helpful for my project. Thank you!
but what if we have two sensors?
You are welcome
@@afiqhassan3122 it will work no problems.
Thank You my brother cause I know diamonds are forever and you are One
you are most welcome
this is helpfull
Thanks a lot
This really helped! Many thanks!!
Welcome
You are great 👌
Thank you so much 😀
wonderful
thanks
it's so encouraging! I just want to know how to add "serial plotter " into arduino, thank you!
use this command : Serial.println(sensorValue);
Can I send excel cell data serially to com port continuously to ardiuno via usb cable connected to PC with ardiuno?
sure,why not
@@DefiningMoment but how to proceed
So the excel reads the serial. Print?
It's not working, a dialog box showing "could not load some objects because they are not available on this machine"
i have the same situation
Please let me know if you got the solution
@@luisfernandomoncayomarulan1208 I have the same problem
Hi, I am getting an error while opening PLX DAQ Excel as " Microsoft forms; could not loan an object beacuase it is not available on this machine"
Hi, I have the same problem as you, did you manage to solve it. Thank you
@@augustin5447 DId you solve the problem 😅
thanks for the great video. Does the excel collect data live?
Yes sir,this was live
@@DefiningMoment Thanks! i have successfully get the data into plx-daq. But how am i going to convert the data to CSV file? hope u can answer this..
Hello
i can save this values 0 to 1024 and i use push-button when i Press the positive button this value increase and when i press Negative button this value decrease instead of potentionmetre ?
That's nice, you can use it instant of potentiometer
Finally a nice music. Relaxing. Can i ask you: is it possible to log more than a value at time?
yes,you can add more video as you want
Thanks for such a helpful tutorial.
Can you please help me figure out how to add one more column?
I am confused about how to modify the command Serial.print("DATA, TIME, TIMER");
do not modify that comand only put a Serial.print(", ) between that comand and your first serial.ptint of your values like this th-cam.com/video/er-x4INAMYs/w-d-xo.html
Thank you so much
Waw, nice and cool video !
thanks
dear Khondaker, I need to use 4 separated sheets of excel to collect four set of concentration potenial (in mv). Can I specify 4 sheets with no. in Plx-daq ? Your help is as always appreciated.
Yes sir, you can do it. It's not so hard. Try it
goodjogb
🥰🥰
Great ❤️
Is it necessary to have a valid subscription in excel or it functions with the cracked version?
it is not necessary.
Thank for tutorial
This code very simple and work...
Many thanks,
Welcome
do you have windows 10 and it works?
I try use window 7 and office 2007,
@@DefiningMoment if we use ads1115 + arduino is use the same code? need for 16 bit
@@ELEKHOB henrysbench.capnfatz.com/henrys-bench/arduino-voltage-measurements/arduino-ads1115-module-getting-started-tutorial/
StampDAQ could not connect.
Please check ports settings
This fault is coming...
Please suggest
thats great,, it means that we dont need to install data streamer add in on excel??
yes, if you follow this method, you need not install that.
I just loaded down a new version of PLX-DAQ V2.11 and checked the debug and all the data is coming through but it's not showing on the spread sheet?????
screenshot please
check your FACEBOOK inbox
many thanks from Taiwan
you are most welcome dear
Good Day to you Sir,
First off thank you for posting this video with download links. My lab partner and I are trying to output some readings from our load cell via arduino to excel. We have already successfully connected our load cell to the arduino and re getting readings through the serial plotter. we have followed all the instructions in your video, but when we click connect through the PLX program, nothing appears on excel.
Please help/respond with any info or reccomendations.
Is it show data in your serial monitor?
@Mahamudul Karim Khondaker yes it is
@@DefiningMoment
I have the same problem, I'm using office 2016. May I know the solution for this issue?
hello Sir,
I have a similar project to deal with, where I have to send the data from an excel sheet via arduino using wifi module dynamically. I am able to upload the data to an excel sheet using this but I'm unableto do the reverse. I want to access the excel sheet and read the data for further processing in arduino.It would be great if you can convey to me and will also help to complete my project to a great extent
Carry on dear,I am with you
www.instructables.com/id/Serial-Port-Over-WiFi/
Hello sir! How can I print attendance log using RFID?
FRID I did not used. Sorry
hi sir actually my arduino board port is 89 but in excel spreadsheet setting port is only 1 to 15 how its connect with port number 89 please
Thanks a lot bro..🙏
You are welcome
Why is it when I follow your instructions mine doesn't work.
Try Again dear,Most of the people already did this.
need to use 2010 version excel ?im using 2016 its error
version is not a big problem, check the method
What if I need 2 value of two different sensor
please watch my other where I explore it.
@@DefiningMoment ok
@@DefiningMoment in which Video do you explain it ? PS: Great Job!
Thank you !!!
Thank you
I got tucked on an excel error "could not load some object on this machine because that are not available" let me find it out what it is.
follow my instruction,I hope it will work
Hi, I have the same problem as you, did you manage to solve it. Thank you
Hello, when i open the Spreadsheet, insted of showing the Microsoft Form message, it apear a message of xls repared that said: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
Can someone help me, I already enable ActiveX in my Excel and still having this problem
follow my instruction,I hope it will work
hi sir ı can find ardunıo to excel data communıcation but ı dont find excel to ardunıo commınıcatıon could you help me
Thanks for the video.
welcome
Hello sir, i want to ask you. If i want to send the data to specific excel file (ex : calibration form), can you give me the guideline? Thank you
I will try, Carry on
On Windows it worked!
Is it possible to make it work on the Raspberry with Debian?
Yes,all are the same
I am getting an error after opening excel that some object is missing from my Device
Reinstall excel and try again
Hello What is Will sensor temperature and humidity dht22
All are the same ,just different parameters
Does Serial monitor work while this excel is connected?And can we take data from a sensor which uses serial communication?If possible,how can we know where the data we printed goes?Hope you reply ASAP.
It works
It's not working, a dialog box showing "could not load some objects because they are not available on this machine" Can you help me out?
You can update your Raspberry PI then try Again.
Hi Sir, I want to ask something. Really Important. Sir, I have 4 ultrasonic sensor, I want to transfer the data from sensor to excel just like your video. Actually I'm not engineering or computer sciences student. But I have to do some research studies. Please Sir. Thank You.
best of luck, Carry on.Hope you will succeed in your project
Mahamudul Karim Khondaker i want to ask. How can I transfer 4 sensor using your method in this video?
You can used arduino,Arduino can scan data from multiple sensor.
How are you displaying time on the excel sheet?
Thanks bro for help
You are most welcome
Dear sir,
The load cell value is plotting values on excel, but I am unable to plot graph on graph sheet, the graph sheet is blank (in your video is ''Register value'') while plotting load cell values, what should I need to do ?
give me some snapshot
@@DefiningMoment I have written you on Facebook, kindly check your message inbox. Thank you friend !!
Is it possible to print 2 different values in 2 different columns? Using serialPrintln again doesn't work because it seems it only transfers to Excel the content of the first serialPrintln you use. Thanks in advance
Yes.it is possible. Look at that video: th-cam.com/video/wlVHJXWSp00/w-d-xo.html
It doesn't work in my Excel 2013 version. What should i do?
Try & check again
THANKYOUUUUUUUUUU
welcome
THANKS
welcome
I have an error when I try to connect , it displays this messge "StamDAQ could not connect. Please check port settings". I have tried with all the ports and I got the same errror. Thoughts?
You need to close arduino serial monitor and try again connect in excel
Can I use this data to plot in python,
Good tutorial. Is it too difficult to write own code without using PLX Microsoft's add-on?
Not so difficult.You can try it.
@@DefiningMoment Do you any tutorial video on how to do that?
y PLX-daq some time it will stop automatically
Due to time delay. Removed the time delay options that's ok.
Thanks for the effort! I am also wondering if there is a way for Arduino to read FROM an excel or txt file?
Excel showing here
Stephen Hawkins? Is it you?
No,I am his friend Mahamudul
while connecting the spread sheet it is showing COM error what does it mean?
Wrong command use
My Exel don't have data streamer in COM add in
How can i get it? Thanks
Sory about my English
Code problem.use my code
how to send and read excel file via UART?
Brother, I already have public some video about IOT and Arduino project. You can follow them.
nice
in expansion of macro 'Serial'
exit status 1
please follow video instruction properly
sir will it work with the windows 10 and the latest excell..
yes sir,It will work
sir, but i still cant open, its state run time error 424
same problem here. the exel has run time error
Can you show me the program writed by arduino app
Arduino code are given in the description box
can you explain what is started time in this case? it doesn't seem to make sense to me. Also, what is registered value? I sent ~2V on A0 and registered value is 420 +/- 2 all the time. What does that mean? :)
Here I have use a veritable resistance . I am continuously changing the resistance value.
Can I send you a screen shot.
Yes,please
Sorry don't know how to attach it.@@DefiningMoment
@@michaelboddy4837 check your Facebook inbox,I have some instruction for you
Hi there! is it possible to change the sampling rate? for example get a value for every 1 msec (1000hz)?
yes, just increase the value of the delay
Hello! Can you tell me what I need to download from Parallax? A screenshoot please
why do you need to download from parallax?
will it work in ms excel 2003
yes sir
Can we take a audio input
please try
how do I get data streamer in Excel 2016?
Already showed
te isiste una gracias
if i want to take data from more number of ports then how?
Just add sensor & scan data to excel.
what is standard time?
Bangladesh time
Necesito hacer eso pero no entiendo cómo meter eso en mi código
English please
I wanna try
yes,you can try
mau tanya, itu pemancar yg di pake namanya apa ya?
Didn't work you have to buy excel
Can use free version
Sir..how about ardunio to Excel android ?
Yes, possible
Like
Where we have to save the program
you can save any where
can you give me your count mail , facebook i want to ask you ?
soumaya nassereddine sure,
My fb : karimmufte@facebook.com
تحية من الجزائر.