next topic »

[on:]

Hey guys i am doing a small project on Data Acquisition from a vernier Caliper to PC.

i was some what successful in transferring the data from Vernier to Arduino Serial window Screen.
but now i want to transfer my data to a Excel file.

 I have used the PLX-DAQ software but i frankly don’t know how to use this software,should we program some where or if we connect directly will it work.

can someone help me out...

[Reply #1 on:]

Hi,

Would you consider writing this with the Processing language?  Only reasons I'd suggest that is it's what the Arduino IDE was apparently inspired by, so the environment is immediately familiar if you're already coding on the Arduino.  Also there's a great series of tutorial videos for getting your Arduino to communicate with a PC using it (by Jeremy Blum) so hopefully it won't be too much of a stretch as you're already writing to the USB port.

I'd suggest writing to a CSV file which Excel will be happy to read from.

Cheers ! Geoff

[Reply #2 on:]

If the caliper provides a serial port design for connection to a PC then I would expect the manufacturer to advise how to access the data from a PC, and usually they would also provide a user-friendly application to manage this for you.

Has the manufacturer provided this information and/or software? If so, why not use it?

[Reply #3 on:]

Excel has some serial port capabilities but you need to write code in VBA. I did it ages ago but it works. I was able to update a chart live with data from arduino. Google how to do serial port in Excel.

[Reply #4 on:]

Hey guys i am doing a small project on Data Acquisition from a vernier Caliper to PC.

i was some what successful in transferring the data from Vernier to Arduino Serial window Screen.
but now i want to transfer my data to a Excel file.

 I have used the PLX-DAQ software but i frankly don’t know how to use this software,should we program some where or if we connect directly will it work.

can someone help me out...

Well I think there are several methods you can use depending on your PC programming skills. I too used PLX-DAQ software a long time ago to import values from an external serial port directly into a Excel worksheet, but it's been some years and I certainly don't remember the details. And as lidur stated Excel has a build in VBA programming language that should be able to link up with a serial port and import values directly, just a matter of learning the programming skills required.
For a 'little' skills required solution you might look into using an PC terminal program (I use Brey terminal, but windows Hyper terminal should work) and have it save the serial data stream from your arduino to a simple text file. Then is a second step just manually import the file into a worksheet as CSV data?

Lefty

[Reply #5 on:]

If I dig up my old project files, I will post here for the OP.

[Reply #6 on:]

If you have managed to get the data into your Arduino, the GoBetwino can send it to Excel, or to a CSV file on your PC.

[Reply #7 on:]

I have great success with the UNO R3 to the serial monitor.  This code actually works without having to learn Process or any other weird libraries.

I a video I think was yours on Youtube...  Can you post the code for your project.  See mine:  supertechqc and on youtube supertechqc.

Does anyone have caliper data code for Leonardo so I can send data in a keyboard function to Excel?