Test and Measurement Forum

Recording data using Excel

Forum for discussing PicoLog

Recording data using Excel

Postby Guest » Thu May 31, 2007 8:12 am

: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
Guest
 

Postby markB » Thu May 31, 2007 10:45 am

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
markB
Site Admin
Site Admin
 
Posts: 83
Joined: Tue Mar 27, 2007 9:43 am
Location: Cambridgeshire,UK

Excell

Postby Guest » Mon Mar 10, 2008 10:51 am

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??
Guest
 

Postby markB » Tue Mar 11, 2008 8:12 am

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
markB
Site Admin
Site Admin
 
Posts: 83
Joined: Tue Mar 27, 2007 9:43 am
Location: Cambridgeshire,UK


Return to PicoLog

Who is online

Users browsing this forum: No registered users and 0 guests