|
|
| Author |
Message |
Guest
|
Posted: Thu May 31, 2007 8:12 am Post subject: Recording data using Excel |
|
|
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

Joined: 27 Mar 2007
Posts: 80
Location: Cambridgeshire,UK
|
Posted: Thu May 31, 2007 10:45 am Post subject: |
|
|
| 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
|
Posted: Mon Mar 10, 2008 10:51 am Post subject: Excell |
|
|
| 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

Joined: 27 Mar 2007
Posts: 80
Location: Cambridgeshire,UK
|
Posted: Tue Mar 11, 2008 8:12 am Post subject: |
|
|
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 |
|
 |
|