ABSTRACT

INTRODUCTION For the Windows-based LabVIEW users out there, ActiveX provides a means of communication among dierent applications. Specically, programs such as Microso (MS) Excel, Word, and PowerPoint provide an ActiveX interface that allows them to be controlled from another application. ActiveX can also be used to embed user interface objects from one application into another. LabVIEW provides full connectivity capabilities to ActiveX, and there are many exciting applications that can be conceived

CONTENTS Introduction 1 Background 2 Challenge 3 Solution 4

Opening an Excel Workbook 5 Reading the Data Set Row and Column Size 8 Reading the Column Headers 9 Adding a Chart 10 Add Series to Chart 12 Adding a Trend Line 14 Complete Integration for Example 15 Macros 15 Templates 23

Conclusions 27 Resources 28

within the development environment. Since ActiveX is an expansive topic and cannot be entirely covered here, this chapter will focus specically on the dynamics of automation of Excel from LabVIEW.