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?