How to use the free Excel add-on to stream data in real time from your Arduino or Raspberry Pi or other serial COM port device and make a realtime chart
Very useful info. Thanks! Is there a way to stream data to an individual, specific cell in real time. We need to use our existing performance data spreadsheets and need to have the data for each cell updated every 500 ms or so. We are getting the data from a Daytronic System 10 DAQ. There is a custom DDE server that we have been using to get the data from the DAQ and stream it to Excel. It worked fine with WinXP, but won't run in Win10 that's on the new PC, even using the different compatibility settings.
I need some VBA help. I am building a paint mixing app using Excel user forms and a serial scale. I am using a DDE server to communicate with the scale. I am having lockups when I go to my display routine.
u r a very wise man, u helped me a lot with this video. Thank you so much sir, Stay healthy.
brilliant idea I have never heard about this option in Excel
good stuff! is there a video on how you are hooked up to the wall outlet? arduino to a DMM?
Very useful info. Thanks! Is there a way to stream data to an individual, specific cell in real time. We need to use our existing performance data spreadsheets and need to have the data for each cell updated every 500 ms or so. We are getting the data from a Daytronic System 10 DAQ. There is a custom DDE server that we have been using to get the data from the DAQ and stream it to Excel. It worked fine with WinXP, but won't run in Win10 that's on the new PC, even using the different compatibility settings.
Very important thing learnt.. thanks..
Is there a way to write (in real time) this streaming data into a database for storage and access at a later time? Would love to see a video on that.
do you know an aproximation of how many days can we record the data
can we gather more than 500 rows of data in excel data streamer ,?
i wanted to connect my weighing scale to excel, so i wont need a medium app for interaction
I need some VBA help. I am building a paint mixing app using Excel user forms and a serial scale. I am using a DDE server to communicate with the scale. I am having lockups when I go to my display routine.
The data is coming in, but I cannot interrupt this routine.
I need a way to store 2400 samples at 4hz.
why esp32 dont get any data 🤔
Good day sir! How did you make the real time be a 1 second difference?
go to settings tab at the bottom of the excel file, then select the Data interval (ms) and change it accordingly.
@@ArkaDutta10 I tried to change it sir but it doesn't appear to be a 1 second difference.
@@johnpaulacorda716 r u using data reading from arduino?...if yes then change the time delay in arduino IDE code as 1 sec.
@@ArkaDutta10 thank you so much sir!