Recording data using Excel

Forum for discussing PicoLog
Post Reply
Guest

Recording data using Excel

Post by Guest »

:arrow: Hello,

I have been working my way through a Humidity recording project and am nearly at the end. The final hurdle is the recording of data. I've found that the pico log software spreadsheet is ok but i would much prefer to convert my data into an excel spread sheet.

Can anyone suggest the best way of doing this.

Thanks

markB
Site Admin
Site Admin
Posts: 83
Joined: Tue Mar 27, 2007 9:43 am
Location: Cambridgeshire,UK

Post by markB »

Once you have collected the data in PicoLog, you can select the spreadsheet data that you want to export and then copy to the clipboard. The data can then be pasted directly into Excel.
Regards

Mark

Guest

Excell

Post by Guest »

Is there no way/macro for Data to be collected directly to excell data sheet in real time without it having to go into Pico first??

markB
Site Admin
Site Admin
Posts: 83
Joined: Tue Mar 27, 2007 9:43 am
Location: Cambridgeshire,UK

Post by markB »

It is possible to aquire the data in excel see http://www.picotech.com/excel.html.

When installing, do a custom setup and ensure the examples are installed. This will put an example Excel file in your Pico directory which will demonstate how to aquire the data using an Excel Macro
Regards

Mark

Post Reply