Creating a Report in Microsoft Excel Using the LabVIEW Report Generation Toolkit: Introduction

Publish Date: Sep 16, 2009 | 83 Ratings | 1.89 out of 5 |  PDF

Overview

This four-part tutorial teaches you how to create a simple report in Microsoft Excel using the LabVIEW Report Generation Toolkit for Microsoft Office for a manufacturing test station. The toolkit is a library of easy-to-use VIs for creating and editing customized reports in Microsoft Word and Excel.



Table of Contents

  1. Features
  2. Begin the Tutorial
  3. Download Example Code

1. Features

You can use the toolkit to automatically create custom Excel reports similar to the following example for a data-driven LabVIEW application, without opening or manipulating Excel manually.



Figure 1. Sample Excel Report


This tutorial covers the basics of inserting data, customizing cells, creating graphs, and combining all the elements to create a report. First, you open a report in LabVIEW and add data to a worksheet either by transferring a table or by copying data cell-by-cell. You then can manipulate the data in LabVIEW or by using VIs that execute macros and functions in Excel. Display the results by creating graphs and formatting cells and objects for professional reports. You then can save, print, or e-mail the report.

Using LabVIEW, Microsoft Excel, and Microsoft Word, you can do the following:

  • Create and edit reports containing text, tables, graphs, and pictures.
  • Populate report templates.
  • Manage report layout and formatting, including headers, footers, page numbers, fonts, borders, colors, text alignment, and so on.
  • Add functions and sort data in Excel worksheets.
  • Run Visual Basic for Applications (VBA) macros.
  • Develop custom report generation functions.
  • E-mail or print reports.

    Back to Top

    2. Begin the Tutorial

Begin the tutorial and start by learning how to load data into an Excel worksheet.

See Also:
Creating a Report in Microsoft Excel using the LabVIEW Report Generation Toolkit: Part 1
Creating a Report in Microsoft Excel using the LabVIEW Report Generation Toolkit: Part 2
Creating a Report in Microsoft Excel using the LabVIEW Report Generation Toolkit: Part 3
Creating a Report in Microsoft Excel using the LabVIEW Report Generation Toolkit: Part 4

Back to Top

3. Download Example Code


Download the tutorial VIs. Requires LabVIEW 6.0 or later, the LabVIEW Report Generation Toolkit, and Microsoft Office.

Related Links:
Buy the Report Generation Toolkit

Back to Top

Bookmark & Share


Ratings

Rate this document

Answered Your Question?
Yes No

Submit