How do I pass data from arduino to excel?
I searched in google but the only programs that appears is PLX-DAQ and it does not work, I get an error 424
help
I did it with V-USB... an Arduino Micro 32U4 can also mimic a keyboard. I have heard of Excel serial libraries add-ins also.
http://www.hackster.io/rayburne/arduino-to-excel-using-v-usb
Ray
mrburnette:
I did it with V-USB... an Arduino Micro 32U4 can also mimic a keyboard. I have heard of Excel serial libraries add-ins also.http://www.hackster.io/rayburne/arduino-to-excel-using-v-usb
Ray
And you can do with the Shield Ethernet using arduino mega?
(translate.google)
This has been discussed on the forum many times.
Try reviewing past posts.
.
Hello, I am working on a project of access control and I need to save the time, date and user that entering the place in an Excel sheet.
First of all I want to do it with proteus by making use of the serial port as shown in the video:
Followed I want to implemetarlo using the Ethernet Shield
The problem is that I find the program to acquire data and transfer them to Excel
I searched in google and many use PLX-DAQ (Arduino meets Excel ( PLX-DAQ ) - YouTube), I install it but gave me an error when opening the Excel
(PLX-DAQ error: "Could not load an object"
followed a window: "Could not load some objects because they are not available on this machine". then I will click on "debug" and a "Microsoft Visual Basic" window opens and displays an error 424: "Stamp.Disconnect ()")
Someone can suggest me a software to send data from Arduino to Excel that run both simulated so much as serial port and Ethernet Shield (And if they have tutorials on how to use it better, thanks)
Thank you
(translated by Google)
Do not cross-post. Threads merged.
new99:
I install it but gave me an error when opening the Excel(PLX-DAQ error: "Could not load an object"
followed a window: "Could not load some objects because they are not available on this machine".
So what version of Office are you using? The common view is that PLX will only work with Office 2003 and earlier. Some have claimed to use it with Office 2010 but, until some proper explanation as to how comes over the hill, I submit it is better not to believe it, and try to beg, borrow, or steal an early version of MSOffice instead.
If the objective is live graphs, you might find LiveGraph suffices. I didn't think it was as good as PLX, but I can't remember why.
The great thing about PLX is the ability to update Excel live, most especially graphs. If live update is not your highest priority, and extra hardware isn't either, you can simply send your data to a proper terminal programme like RealTerm, record it to CSV, and open that in Excel at leisure. I don't raise this an an option of last resort, but as an option everybody seems to forget about.
Last year I reported that I had PLX-DAQ working with Excel 2010 on my win 7 Pro x64 machine using a Teensy. I have since tried it with an Arduino Nano and it also works.
In that thread, Nick Pyner's reply was:
Nick_Pyner:
Quite a triumph, all the same.
Now in this thread he says:
Nick_Pyner:
Some have claimed to use it with Office 2010 but, until some proper explanation as to how comes over the hill, I submit it is better not to believe it
So, now I'm a liar? I submit that you haven't got a clue what you're talking about.
What kind of "proper explanation" does Your Holiness require?
- Install PLX-DAQ.
- Start up the PLX-DAQ xls file.
- Select OK when the warning pops up about ActiveX
- Make sure that both ends are using the same baud rate.
- Make sure that both ends are using the same COM port (and note that
PLX-DAQ can't handle ports above COM15). - Leave "Reset on Connect" SELECTED
- Leave the other four checkboxes unselected
- upload your code to the Teensy/Arduino
- then select Connect in the PLX-DAQ dialog.
Is that "proper" enough?
If anyone is having a problem with PLX-DAQ connecting it may be because their sketch is not waiting for the Serial object to be instantiated and then delaying a second or two just to make sure the connection has had time to establish. To do this, just add these two statements after Serial.begin(19200)
while(!Serial);
delay(2000); // May not be necessary but it's only two seconds out of your life
This code works - I've just tried it (again) with Excel 2010.
// PLX-DAQ is only specified to work on Win 98 (!) and
// Excel 2000 to 2003. But this works on Win 7 with Excel 2010
// Tested with Teensy3.2 and Arduino NANO
// It does not like data being sent at it too fast.
// It seems to be able to handle 9600 at full speed
// but it crashes/hangs at 19200 or higher.
// The delay(10) at the end is needed for speeds greater than 9600
int x = 0;
int row = 0;
void setup()
{
Serial.begin(19200);
while (!Serial);
delay(2000);
Serial.println("CLEARDATA");
Serial.println("LABEL,Time,x,sin(x)");
}
void loop()
{
Serial.print("DATA,TIME,");
Serial.print(x);
Serial.print(",");
Serial.println(sin(x * PI / 180));
row++;
x++;
if (row > 360)
{
row = 0;
x = 0;
Serial.println("ROW,SET,2");
}
delay(10);
}
However, the problem that @new99 is having seems to be more with the environment in which PLX-DAQ is being installed.
@new99: Which version of Windows are you using and which version of Excel?
Pete
I said "common view", and it certainly is that. I don't have a problem, I don't use Office 2010 but plenty of others do and have grief with it - to the point where "My PLX won't work" seems to be a problem exclusive to users of later versions of Office.
@new99:
If you use Google with the search string "Could not load some objects because they are not available on this machine" (and that INCLUDES the quotes), you will get some hits about similar problems some of which may have a solution for you.
I think that PLX-DAQ uses the Solver add-in for Excel. If you haven't got Solver installed that might explain the error message.
Pete