How to Read Arduino into Excel!
ฝัง
- เผยแพร่เมื่อ 25 พ.ค. 2024
- Let's use a handy Excel add-in to get data directly from our Arduino board, huzzah!! This video I show you how to do that and what you can do with that data to see all the interesting things.
To learn more, check out the Using Arduino for Citizen Science tutorial here: foxbotindustries.com/using-ard...
To get Data Streamer, download (FREE) here: aka.ms/DatastreamerForExcel
Like these videos? Please support my work by contributing to patreon: / jenfoxbot
![[LIVE] : ONE ลุมพินี 64 | คู่เอก "พาร์แฮม vs จอร์แดน"](http://i.ytimg.com/vi/yg2mS5U2aB8/mqdefault.jpg)
Muito bom, funcionou! Obrigado!
Sabe como faço para o sensor escrever direto no MS SQL Server sem interface de outros programas, assim como foi realizado neste do Excel?
Una pregunta donde puedo encontrar la guia de la que hablas sobre tu sitio web Arduino, en donde explican el paso a paso de Arduino a Excel?
Thanks Jen, been looking how to do this for a while. I've got to plot 4 batteries through their discharge cycle and this is exactly what I needed.
that's a fascinating application! Glad the video was helpful and thanks for sharing 😄
Good tips thanks, FYI your camera was struggling because the pc screen pulses in brightness and that throws off the exposure control of the camera. If you haven't figured this out already set your camera to manual focus and exposure and dial in your levels before starting. Also it's pretty impossible to get good shots of a screen so that's why people turn to screen cap overlays obviously.
Hi, Just wanted to know whether data in excel file can be read by arduino or any other system so as to control relay switches for electrical components in a circuit. If i have a data in excel file and based on values in certain cells i want to perform a certain specific function in circuit for e.g. first row and first column cell info if is equal to 1 then switch on red Led light.
Please guide me . You are making wonderful educational videos .Keep up the good work. Thanks
Good question! Yes, you can send data to the arduino board using the datastreamer add-in. Once you've set updatastreamer, you should see an excel sheet titled "data out", which is where you can send values to arduino. In the arduino sketch, you can set actions depending on those input values.
If you go to aka.ms/hackingSTEM and look for the "party lights" project, the code for that project will give you an example of how to do this. Hope that helps!
Good morning Ma'am, I just wanted to give an update, and ask a question (which may be a separate post if this is too long).
I downloaded the data streamer add in, connected a circuit playground express and mashed a few example sketches together to use the sensors on board, separated by commas (at bottom of post). Connected device and started streaming data. Very cool, it was that easy, I didn't need to configure channels as it automatically set up 5 input channels!.
One thing I did notice is that when I set the time delay to 10000mS, while it did update every 10 seconds, it imported 10 measurements at a time (the arduino code has a 1 second delay) rather than one measurement at a time.
My question, which I posted on your website and I apologize if I missed the response. Are there any plans to extend the amount of recording rows and/or extend the data interval time? For instance sometimes I will measure the discharge rate of some batteries which require some time to collect that data or I may take some temperature measurements over a day or two with a delay of 10 minutes or so.
I think this is an awesome feature and really was super easy to use, thank you for working on this and please keep posting amazing and informative videos. They are appreciated.
-----Sample Code-----
#include
float tempC, tempF;
int value;
float X, Y, Z;
void setup() {
Serial.begin(9600);
CircuitPlayground.begin();
}
void loop() {
tempC = CircuitPlayground.temperature();
//tempF = CircuitPlayground.temperatureF();
value = CircuitPlayground.lightSensor();
X = CircuitPlayground.motionX();
Y = CircuitPlayground.motionY();
Z = CircuitPlayground.motionZ();
//Serial.print("tempC: ");
Serial.print(tempC);
Serial.print(",");
Serial.print(value);
Serial.print(",");
Serial.print(X);
Serial.print(",");
Serial.print(Y);
Serial.print(",");
Serial.println(Z);
//Serial.print(" tempF: ");
//Serial.println(tempF);
delay(1000);
}
That's so awesome!!! Very happy to hear you got it up and running!
In terms of more data rows, unfortunately I don't think it's possible with the current way excel does calculations. The 500 row limit is a bandwidth limit cause theres a ton happening in the background and anything more just crashes the program. But, you can definitely send a request to the hackingSTEM team to let them know you're interested! You can submit here: aka.ms/hackingSTEM
Hope that helps!
@@JenFoxBotThank you for making such a lovely video. I have a question that is similar to @Paul Ramasco's. I'm working on a project that requires data to be collected every 300 milliseconds for more than 30 minutes. As a result, the 500 rows are insufficient for data streaming. I noticed that the data streamer can handle 1 million rows on some PCs but only 500 on others. Our current conclusion is that data streamer will allow 1 million rows on computers with a core i7 processor, but only 500 rows on pcs with a core i5 processor or less. Have you had a similar experience? Is their a way to raise the number of rows from 500 to 1 million without having to upgrade the computer processor?
@@abdullahiibrahim7796 thats a great question! As far as I know the 500 live data limit is due to rhe speed with which excel can process data, so your finding re: computer processor seems accurate. You could try a virtual machine via cloud maybe? That would cost money but likely less than upgrading computer.
Does your data need to be live? If not, you could store to a txt file and import into excel later.
Thanks for sharing Jen, will the excel sheet be updated automatically?
Good question! Yes, datastreamer updates the excel sheet, aka the data is in real time!
A question where can I find the guide you are talking about on your Arduino website, where they explain the step by step from Arduino to Excel?
Apologies for the delay, here ya go: www.hackster.io/HackingSTEM/stream-data-from-arduino-into-excel-f1bede
Thanks for this, Jen. I was concerned that the streamer was only for Office 365 - that's the impression they gave. But no, it downloaded just fine for my "real" Excel. And moreover, it works. Without this I had written a long VBA script to achieve the function, but this is easier.
Glad you found it useful! Last I heard, as Microsoft moves more to the subscription model, other teams w/in Microsoft are having to move that direction as well, hence why it is only "officially" supported on O365. But folks that work on the teams try hard to make sure it is still backwards compatible :) Hope you get some good use out of it!
...late to the DataStreamer...can you help enable this for my Excel2010 ?
It worked!! Thank you so much! I was looking exactly for that!!
Yayyy that's awesome !!! 🥳🥳🥳
What do you mean by separate the points with commas? I'm using the DHT11 tester sketch and am extremely new to arduinos. I'm not sure how to get the readings into separate columns
use the Serial.print or Serial.println function. The below code should do it:
Serial.print(MySensorValue1);
Serial.print(", ");
Serial.print(MySensorValue2);
Serial.println();
Is there a way to write (in real time) this Excel streaming data into a database for storage and access at a later time? Would love to see a video on that.
thanks for the video you have been a good help, I have a small issue : when I press on (connect a device) then press on (Arduino) it doesn't connect although I tried multiple ports and the program runs just fine on Arduino IDE still the same problem. plus it doesn't show any error messages.
Glad to hear that the video was helpful! Since it sounds like the Arduino serial monitor is working, I'd suggest reaching out to the Datastreamer support folks: aka.ms/supportpage
This is such an amusing video to watch!! Thank you for your enthousiasm :)
aww yay, thank you for the kind words! 😄😄
Hi Jen,
Based on what I read on the MS site where the Data Streamer is offered for download, it seems that Windows 10 and Excel 2016 with a subscription to Office 365 are the minimum requirements or as I call them, 'prerequisites'. I am searching for a similar straightforward solution that will work in Windows 10 with Excel 2013 and not require a subscription? Is there anything out there that can do this? Any way that will not require Python nor any other Arduino Shield, nor other computer hardware, nor a subscription?
Ah yea for better or worse Data Streamer is only officially supported with the O365 subscription. I feel you about software subscriptions.. typically not a big fan. It's a nuanced problem tho since Microsoft is obsessed w/ security and can only guarantee security if they are able to patch updates, which often needs a subscription model to continue paying developers for security fixes and such.
As an alternative, you could do some in-house coding in Excel Visual Basic, see if your version has an API that you could call, or write a Python script to process the Arduino data and then import manually (or via the API) into Excel. Hope that helps.. Let me know if you have any other questions!
@@JenFoxBot Thanks for your knowledge in this area. I never thought that I would be called on to write anything in Python. And I have written a few lines of VB, but that too would be a test for my skills. What I cannot understand is how hard it is to find any prior case where someone has already solved this puzzle.
Love your video and enthusiasm!! However, if i understood correctly, there is a limit of 500 data values in one recording? If yes, then it is not enough for my application. But thanks for sharing anyway. Looking forward to your next videos! All the best.
thanks so much for the kind feedback! the rate limit is how fast you can send a chunk of data... it's been awhile since i looked at it, but i believe it's 500 data pts per second? otherwise you can record as much data as you want by just letting it continue to stream in. hope that helps!
To combine the video with showing Excel, you can use Open Broadcaster Software (obsproject).
Nice feature. Thanks for sharing.
Glad you enjoyed it! :D
Nice demo. Looks like the data streamer add-in is only for the MS Office 365 version. I've been using my 2000 Pro license since back when I purchased until the last year or so. I do have a Office 2007 Enterprise Ed. I invested in also back when I was working on my second B.S. programming... though have never used. I think it was last year I decided to just use LibreOffice and even with that I hesitate to upgrade to the newer versions since a few months back I broke down and invested in a Win 10 build. Now, my question... are you aware of a plugin (app, macro or script I'm guessing is since reads like the add-in is a Visual Studio object coded somehow to sync with the data stream for the MCU's designed for) that will work for the older MS Excel or Libre Office? Thanks for sharing and in advance for your time.
Not sure if this is the easiest method with Open/LibreOffice Calc... I'm sure there is an easier way... just not there yet. However, Google translate this page if you don't know Spanish and looks like the gentleman solved my question (and saved me some coding) with your inspiration of course: autron.blogspot.com/2013/12/comunicacion-de-arduino-con-hoja-de.html
If you figure anything else out... please note. I'll do the same since I am still wondering about like VB scripts or macro maybe, though haven't read into for LibreOffice ever and might do that next. I know there are some Visual Basic script or macro methods to scrape data from txt or HTML documents and seems like can from a COM port also to save on the buffer file created and read from.
Thanks again!
Humorous... I just found that the gentleman did the same thinking I was in regards to reading the serial port and making a custom (I guess compiled executable, though the link looks broken) app to read the serial port. Strange though is he didn't output the data directly to a spreadsheet since there is a lot of code (or was a decade ago) online to literally open and manipulate Excel spreadsheets at least with Visual Studio 2003 and earlier whatever language using to code the app (VB, C++ or C#). Huh... I still need to read into... though figured I'd post here and note in case anyone decides to not use a Database application if their data sets are going to be small (I'd use a Database eventually, though for like I'm thinking just date time stamped events and like an audit record report not needed the database output stream) and wants their data streamed to a spreadsheet application. autron.blogspot.com/2013/12/generador-de-tabla-html-por-puerto.html
Found this method also (link below from Arduino) to create the txt or csv file directly from the Arduino serial data stream using CoolTerm (like above method). So thinking just a simple VBA or whatever the Libre/Open Office is called script macro to import into Calc, Excel or whatever you're using with the Arduino data log, i.e .txt or .csv, file with the graphs you want also.
www.arduino.cc/en/IoT-Prime/Experiment02
My apologies for all the comments, though figure I can come back and search my history to review what I posted and others can see if need too. Maybe I'll make a TH-cam video regarding the whole process once I determine how to make the LibreOffice Calc spreadsheet with script macro for this purpose. Seems I can have the spreadsheet open the CoolTerm or whatever terminal app (once the terminal app is configured) if I can't figure out how to read the serial data stream with Calc alone in a script macro. Thanks again! :-|)
@@jafinch78 Heck yes for searching for solutions! It sounds like your tenacity and curiosity helped you to resolve the problem, and I definitely appreciate the resources both for myself and for other folks. That said, I'll add my 2 cents in case it is helpful.
As you discovered, the DataStreamer add-in is now only officially supported on Office365, although older versions were compatible with other versions of Office/Excel. I am unsure where those live, or if they are even public. If you still need that, or if you're curious, you might be able to get a link to an older version if you ask the HackingSTEM team (the folks that created DataStreamer): aka.ms/hackingSTEM
Another option might be to view the source code for DataStreamer and see if you can adapt it for your needs. Even without Office 365, if you're able to download the package you could always open it in another program like VS or notepad to see how it functions.
Hope that helps! And thanks again for being proactive in finding a solution :D
(Also, my apologies for the delayed response -- went out of town into nature for a few days for some much-needed respite and relaxation.)
@@JenFoxBot Your welcome and thank you for the motivation. Awesome you got some natural resources time... that's the best usually. I've lived off the grid and traveled for a few years and sure am missing that now. I did some outdoor projects this last year, though are more small engine related projects so kind of gross. Anyhow..., the more information the better I think... 2 cents is better than none and some good thinkin Lincoln even if we learn what not to do.
I was just reading The Code Project Insider earlier today ( www.zdnet.com/article/microsoft-postpones-end-of-support-for-some-windows-10-1709-versions/) and found out Jan 14th 2020 was the end regarding Win7 and looks like Office365 is being extended out to Jan 2023. I noticed I typo'd in my FB post comment linking to this and so I don't forget: facebook.com/james.analytic/posts/3734186629976445
I doubt that post will go anywhere... though just in case... here is the other Serial Port Monitor I forgot I had, though noted and will note here too since is open source and modifiable for those that are code savvy:
github.com/ahelsayd/Serial-Lab
I'd take a copy of the earlier Windows Excel/Office 2000 Pro compliant DataStreamer if you have... though I'll not bother the hackingsSTEM team since I have enough to do and am content with using the LibreOffice version I'm using and am feeling I can probably use something even less resource intense too to save processing speed. I have a feeling if I can appropriate the time... I can custom code something even if just using a batch file script (.bat) so I click on the one batch file to open up the Arduino IDE, the Serial Port Monitor and the LibreOffice Calc/Base app.
Figured out a few macro methods also to select the last cell in the first column so the data always appends in LibreOffice Calc when you open the app. Also, so the spreadsheet always open a specified file to import, which doesn't need a macro for that task actually... though does to assure the appending on opening process is correct with the selected cell at the last blank row and first column or wherever. Couple ways to do that task in a macro... and there is an interesting macro recording capability I've never seen before to make the task of making macro's themselves easier.
Made a post on reddit also regarding... though just checked and no reply. www.reddit.com/r/libreoffice/comments/fk9r76/libreoffice_serial_data_stream_import_or_csv_file/
Thinking I can edit to add references to the macros I found examples of using, now that I think about. Thanks for the reminder... I'm off on other projects for the day. :-|)
I'll keep you posted if I find anything else out. Thanks again and no need to apologize! That's excellent you got to enjoy some time out and I hope you've got stuff to do.
Hi,
Can we read data over Modbus TCP over internet?
Nice video, really helpful.
Thanks! Glad you found it useful 😄😄😄
Is there any way to change the color based on the output number? (example if the number outputted is in between 80-90 then yellow and if it’s between 91-100 turn red)
I believe so! Pretty sure you can still apply conditional formatting to those cells that changes as your data changes. If you are unable to edit those cells, id judt create a new sheet with cells that point to the incoming data, and then apply your conditional logic there. Hope that helps!
@@JenFoxBot Yes! Thank you so much!
@@Koko-cq7fb yayyy its the best feeling when it works!
hello,
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
Hello! I am familiar with how to download data directly from Excel, but have never accessed it remotely before. There may be an API protocol for Excel, try searching around for that or ask the Excel folks directly. Best of luck with your project!
How did it work, that one value is shown on CH1 and the other one at CH2, when I try this, i see both values at CH1, may you show me the Arduino sketch?
Add commas "," between each printed data value-- excel datastreamer separates the data points when it sees a comma. Sample code:
Serial.println(value1);
Serial.println(",");
Serial.println(value2);
Hi jen, nice video...i have tried excel data streamer, working fine with arduino uno...
one problem i have faced which was baud rate of excel data streamer, it must be same to that is used in arduino program...
Very glad to hear you got it working w/ Arduino Uno! And yes, you are correct in that the baud rate must be the same as in Arduino Serial Monitor (9600). If you want to use other microcontrollers, you can adjust the baud rate in the options setting in the DataStreamer tab. Hope that helps!
@Muhammad Adeel >> I hope u fine
do you have a cracked excel or u r legally subscribed????
@@moazmohamed5737 I had installed/added data streamer add-on to my installed MS Excel from Microsoft website. . . Note that my office was neither registered nor cracked infact it was unregistered.
Hello! I love your explanation but I can't understand how can I send data (with data out function) to arduino. Is it necessary any specific code? I hope you answer me
Aha! Sending data to arduino can be done in the "output" sheet -- you can type what you want there (use eqns to get values that change), and then add some lines in the arduino code to handle the input (via serial I believe? Its been a hot sec but I think there's info on the excel output sheet). Hope that helps!
@@JenFoxBot Hello, I'm also having some trouble sending data out and this part isn't as much documented as "data in".
I have followed your sample code from www.hackster.io/HackingSTEM/stream-data-from-arduino-into-excel-f1bede#code but no string comes out of Excel. Is there something else to do other than writing data in the specified cells?
Nice video, I have a question about, how to split the Arduino datas column, because i have 3 sets of column data. In these 3 sets of data was come in a single column in excel. And how to increase the number of rows bcz i can set only 500 rows in excel.
Add a comma between each data pt in the arduino Serial.print() statement to separate data into distinct columns. I don't believe you can visualize more than 500 rows at a time, I think its a limitation w/ excel. But you can transfer the incoming to another sheet to store it!
@@JenFoxBot Thank you for your information
Thank you so much Jen. You made my data logging problem seems like nothing...Cheers
Yayyy so happy to hear that!
Super cool, I'll be updating my heat transfer calcs now with REAL data
Woohoo!! Heck yes for data 😄
Can you help with some code for a transducer monitoring?
Hi Jen... I'm no Excel guru, but here's the question. Can Excel analyze while the data is coming in? Let's say we wrote a formula (for your demo) that said [ if column A value is between 55 and 74, change text color to green telling us the temperature is within ideal range for your spider plants]
I'm visualizing an RFID reader that matched incoming ID's with ID's on another $heet, and populated column 3, etc, with the product description, product cost, blah, blah.... live on the fly.
Aaaaaand..... thanks for taking the time to do this video!!
yes -- you can do real-time analysis and visualizations (like graphs) with the data! There are some incredible visuals that this team made if you want to check 'em out: aka.ms/hackingstem
i'd recommend doing exactly what you're doing now: make a new sheet where you reference or pull in the live data and then do the analysis/visuals there. Hope that helps!
Can I use Excel 2016? I don't see the Data Streamer com add-in in Office 2016. How do I get it without installing 365?
Ah unfortunately Data Streamer is only supported in the O365 version since Microsoft isn't able to support all of the old versions of Excel.
Hi...Jen..
Can u suggest how to send excel cell data to arduino serially in realtime?
You can do this with the DataStreamer add-in, although it now requires O365. If you have that, you can go to the "data out" page and input things into the fields that will then be sent to Arduino.
If you're don't have O365 or DataStreamer, look for the Excel API for your version of Excel.
Hope that helps!
@@JenFoxBot can I have your email address?
Cool! Can I use it to graph real time data online?
Like on a website or something? I believe you can do this fairly easily with Office 365. This website should help with that: docs.microsoft.com/en-us/graph/excel-concept-overview
Hope that helps!
Hi,Jen!
Is there any way to read data from excel files?
Hello! Do you mean like exporting an excel file?
Data streamer does allow you to send commands to the microcontroller in the data out sheet, but unsure if that's what you're looking for.
@@JenFoxBot In this video data is exported to excel.My question was about importing data from excel or. txt files.
@@MahmudulHasan-eq7ug you can import text files or other CSV data into excel. You can save an excel file as a PDF but unsure about exporting text files. Theres always copy and paste, tho! Slash there might be an API for that.
FUCKING LIFE SAVER THANK YOU SO MUCH JEN!!!! I have to do a lot of work with my Arduino for my masters degree in space systems engineering and you saved my life thank you!
I'm so glad to hear its helpful for your masters !! I hope you enjoy your program even if its a ton of work, you got this!
really helpful tut... Thanks
Glad it was helpful!
Thanks !!
Happy to help!
Great jon Jen
Thank you!
thak you...thats cool
Glad you like it!
Unfortunately I can't get the esp32 to work with it ... do you have any idea,why? it recognizes there is a serial device but there is no data, plx-daq reads it without difficulty.
most likely it's the baud rate -- default for esp32 is 115200 whereas data streamer default is 9600. you can change the data streamer baud rate in advanced -> settings. Hopefully that does the trick!
No, that's the first thing I tried, changing the baud rate for the code and changing it in Data Streamer, arghhh this add-in was so very usefull for me, if I got it working, the arduino nano works great with it tough(i'v tested it) , do you have any other sugestions, for me to try ?@@JenFoxBot
@@badeakristoferson664 hmm that's weird! Can you get the esp32 to print to the arduino serial monitor? Data streamer works almost identically to that so if that works there is prolly something we can do to get it into excel
@@JenFoxBot yes ,the esp32 works perfectly with arduino ide serial monitor
@@badeakristoferson664 ok, that's good news! How are you printing data? data streamer requires data points to have a comma in between with a new line st the end, like this:
34, 230, 24, 42, 4
23, 243, 38, 42, 5
What does the arduino serial monitor output look like ?
Thanks
Hello is it possible to use an input key to open a python file with usb serial?
Great question! Unfortunately I don't have any experience with that... I'd recommend doing some research on COM communication which is how Arduino boards communicate w/ a computer, and also how Excel grabs the data. This might be helpful: www.martyncurrey.com/arduino-and-visual-basic-part-1-receiving-data-from-the-arduino/
@@JenFoxBot thank you so much for your kindness and courtesy
@@ADVICESTECHNO absolutely! Happy to help 🙃
@@JenFoxBot hello jen foxbot I'm happy for starting and interacting arduino uno with python via serial to start applications with the arduino button the code if you want to use it is in the info under my video box of my under bye :)) th-cam.com/video/5y5raqG76EQ/w-d-xo.html&ab_channel=ADVICESTECHNO
th-cam.com/video/f3G6rTi42dU/w-d-xo.html
the data streamer is not getting installed on my device though i have official licensed ms office , it's saying - "the certificate used to sign the deployment manifest for Data Streamer or its location is not trusted. Contact your administrator for further assistance.
" what should i do mam.
Well, foo! Do you have O365? I believe it's only supported for that version of office these days
@@JenFoxBot yeah I have the licensed version of office365
hi mam 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
Hmm your arduino board should be sending data through the COM port. Do you mean you want more rows or columns of data in excel?
@@JenFoxBot no mam actually i want to say my arduino uno connected with COM port 89 number but in excel sheet COM port setting is 1 to 15 then how i connect the plx-dax
@@naveenvaid4318 ah, gotcha. Datastreamer should auto detect the arduino if it is connected correctly, it's not limited to COM ports 1-15. Where are you seeing that?
HI >>> thanks for your great video >>there is no direct link to download free data streamer>> could you help me in this issue?!
aka.ms/datastreamer
You'll also need O365 for it to work properly (older versions were supported in older versions of Office, but it requires a lot of effort to maintain that kind of support and the team that created and maintains datastreamer is fairly small -- if you do download it, know that your interest helps the team grow and get more support!)
Hope that helps!
@@JenFoxBot so i should be legally subscribed!!?
@@moazmohamed5737 you mean pay for the software? Well, yes, if you want it to work properly and with full functionality :P
@@JenFoxBot i forgot to ask you about the version of your excel?
could it work for office2016?
@@moazmohamed5737 the datastreamer addin is currently only officially supported for O365. But the more folks who request support for other excel versions, the more likely it is that it will get approved!
How can i separate the data into different columns?
with commas!! :D (in the arduino code, just add a comma after each data point)
You should record your screen using camtasia software
Very awesome!!! No more PLX-DAQ.
Heck yes!!
The link to get Data Streamer is not working 🙁
nooooo!! try this: aka.ms/datastreamerforexcel
@@JenFoxBot Thanks a lot Jen... I can download and install it. It's really helpful. 🙂
Good morning Ma'am, could you explain more clearly. I try to do, but i does not work :((
What issues are you running into slash where are you stuck?
1:20
it will be much better if you share your pc screen with us and then record the video
eğer bilgi paylaşmaksa amacın ekranı göster, kendini değil. screen capture.
Hi!
How can I transfer the data from Arduino to Excel using a Wi-Fi module in real-time?
Datastreamer uses the COM port to add in data, so it wouldn't work via wifi. Buuuut I would expect someone has tried that.. i believe Excel VBA has an API you could try using!
We can't see Shitt