User Manual
Programmer's reference39
Copyright © 2005-2010 Pico Technology Ltd. All rights reserved.adc20.en
5.5.3
Excel
The easiest way to get data into Excel is to use PicoLog for Windows. If, however, you
need to do something that is not possible using PicoLog, you can use an Excel macro
to read in a set of data values. The Excel Macro language is similar to Visual Basic.
Excel 2002
The example HRDL.XLS reads in 100 times and values from channels 1 and 3, at 121
ms for both channels, and assigns them to cells B4..C103. The times are stored in
cells A4..103.
5.5.4
LabVIEW
The routines described here were tested on Windows XP using LabVIEW 8.0. We can
provide older versions from 6.1 and 7.1 upon request.
While it is possible to access all of the driver routines described earlier, it is easier to
use the special LabVIEW access routine. The HRDL.vi library in the installation
directory shows how to access this routine.
To use this routine, copy PicoHRDL.dll to your working directory.
You can use one of the sub-VIs supplied for each of the channels that you wish to
measure. The VI accepts the handle and the channel (1 to 8 for ADC-20, 1 to 16 for
ADC-24; only odd-numbered channels in single-ended mode) and returns the voltage
in millivolts.
5.5.5
Visual Basic
Version 6
The installation directory contains the following files:
HRDL.VBP
HRDL.BAS
HRDL.FRM
5.5.6
Agilent VEE
The example routine HRDL.vee is included in the SDK. It was tested using Agilent VEE
version 7.5 on Windows XP.
The example shows how to collect readings continuously from the data logger.
VEE also requires a header file, HRDL.VH. This file is installed with your Pico software.