- LabVIEW Projects, pt100 arduino, data logger arduino, esp32 temperature sensor, arduino excel, serial plotter arduino, excel arduino, arduino sensors,arduino.
- Live Data to Excel From an Arduino Light Sensor: I started this little project the other day when I saw that Instructables had posted a competition for the use of Sensors, however its turning out to be a bit more interesting.
- When I started down this path to use an Arduino as a data acquisition system, the stumbling block for me was how to get the data from the Arduino directly into an analysis tool like Microsoft Excel. I wanted a method that was easy, robust, low cost, and wasn’t a long time-consuming process involving hacking a lot of code.
- Sep 04, 2010 Easiest is to just have your Arduino program write data as numbers separated by commas. For example: 12,34,56,7 9,-3,5,23. Then, use a terminal program like TeraTerm, Hyperterminal, BrayTerm, etc. (instead of the built-in Serial Monitor) and use the 'log to file' feature which saves a copy of everything you see in the terminal to file.
Most recent version 2.11 to be found here:
http://forum.arduino.cc/index.php?topic=437398.msg3251256#msg3251256
Arduino Data Acquisition Into Excel For Mac Software
Download specific versions directly:
v2.0 - v2.2 - v2.3 - v2.4 - v2.5 - v2.6 - v2.7 - v2.8 - v2.9 - v2.10 - v2.11
v2.0 - v2.2 - v2.3 - v2.4 - v2.5 - v2.6 - v2.7 - v2.8 - v2.9 - v2.10 - v2.11
So well well well - here it is
Works just fine on Win 7 Pro x64 with Excel 2010. It does require that you allow the macro to run by changing the security level. One minor problem I had was that it only seems to allow COM port numbers up to 15 and the Teensy I was using was COM30.
I have re-written the well know PLX-DAQ to be able to be run on modern Office suites.
What’s new in 'version 2:
- Support for both Office versions 64 bit as well as Office 32 bit
- No more installation needed! All within the workbook
- I got rid of the selmaDAQ_Ver2.ocx and use API calls now
- Fully compatible to all previous PLX-DAQ commands in your code!
- Got rid of some old stuff like “Max row size of 65000” (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
- Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
- Setting for selecting where to post data (first most left sheet or currently active sheet)
- Disabled the control boxes as Stamp object is no more in use
Tested the code on Windows 7 64bit with Office 2013 32 bit and Office 2013 64 bit - both are working fine.
I would appreciate if anyone could test it further on other operating systems (maybe Mac as well ) and Office versions and post feedback.
I would appreciate if anyone could test it further on other operating systems (maybe Mac as well ) and Office versions and post feedback.
Arduino Data Acquisition Into Excel For Mac Os
All source code is available within the Excel, no more closed DLLs !
Attached is a default sketch as well for you to test the new PLX DAQ if you want to.
Attached is of course the new Worksheet with the new Macro as well.
Attached is of course the new Worksheet with the new Macro as well.
If you have questions please feel free to ask
Well - it is nearly 2am in Germany right now … this is going to be a short night …
cYa !
Image-Link:http://www.freebie-base.de/Pics/PLX_DAQ_v2.png (hosted on my server, no traffic hijack)
(This is just for all google folks that are trying to get PLX DAQ “version 1” to run and have the “Stamp.disconnect” error - this new version will solve the issue!)
> https://forum.arduino.cc/index.php?topic=437398.msg3013761#msg3013761 <
This version (v2.00) is already outdated !! Link to always most recent version of PLX DAQ v2 above
PLX-DAQ-v2.zip (108 KB)
PLX-DAQ-v2-DefaultSketch.ino (511 Bytes) Macbook xbox 360.