Recording data using Excel

 
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
Author Message
Guest






PostPosted: Thu May 31, 2007 8:12 am    Post subject: Recording data using Excel Reply with quote

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
Back to top
markB
Site Admin
Site Admin


Joined: 27 Mar 2007
Posts: 80
Location: Cambridgeshire,UK

PostPosted: Thu May 31, 2007 10:45 am    Post subject: Reply with quote

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.
Back to top
Guest






PostPosted: Mon Mar 10, 2008 10:51 am    Post subject: Excell Reply with quote

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??
Back to top
markB
Site Admin
Site Admin


Joined: 27 Mar 2007
Posts: 80
Location: Cambridgeshire,UK

PostPosted: Tue Mar 11, 2008 8:12 am    Post subject: Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group