Measurement Computing DaqView - Manual (Page 75)

987691
457-0913 rev 3.1
ViewXL
Software Reference
Overview …… vxl-1
Program Requirements …… vxl-1
Installation of ViewXL Add-
in …… vxl-1
Menu …… vxl-2
Toolbar …… vxl-3
Using the ViewXL Program API …… vxl-8
An Example Macro …… vxl-9
ViewXL API Definition …… vxl-11
Overview
ViewXL is a Microsoft Excel Add-In that provides setup and data acquisition for personal computers
running 32-bit versions of Microsoft Windows. The features of Excel and the selected data acquisition
server, for example, ChartView or DaqView, combine seamlessly to form a powerful data acquisition tool.
ViewXL:
Augments Microsoft Excel with data acquisition capability.
Automatically converts data to engineering units.
Allows multiple data acquisitions [obtained using auto-rearm] to be
placed into multiple worksheets.
Can import data from previously acquired data files.
Once the ViewXL add-in is installed, a ViewXL toolbar and related menu appear in Excel. These provide
all configuration and data acquisition controls.
With ViewXL, you can obtain automated reports by taking advantage of the Software Components
concept. For example, you can embed an Excel spreadsheet object into a Word document. When the
spreadsheet object is activated, it gives you access to ViewXL. In this case, the Word document holds all
text, as well as an embedded Excel worksheet object. The Excel worksheet object holds raw and calculated
data and graphics.
Double-clicking on the Excel worksheet object in Word can access ViewXL, allowing the user to
efficiently prepare a statistical report. This compound document allows you to collect, configure, analyze,
graph, and annotate data, with a just a few clicks of a mouse button.
Program Requirements
ViewXL requires the following software:
A data acquisition server application, such as 32-bit ChartView or DaqView, that can implement the
View-App Interface standard.
Microsoft Excel 2000 or later
32 bit Microsoft Windows Operating System (Windows 2000, XP, or Vista)
Installation of ViewXL Add-in
ViewXL is a standard Microsoft Excel Add-in. It is installed by selecting the Excel Tools/Add-Ins menu
item. If ViewXL does not appear in the list of available add-ins, press the Browse... button, and then select
the ViewXL.xla file. When the Add-In appears in the list, click the check-box next to ViewXL to
enable the program.