Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

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

81 ratings | 1.86 out of 5
Print

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

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.

    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

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
81 ratings | 1.86 out of 5
Print

Reader Comments | Submit a comment »

 

Legal
This tutorial (this "tutorial") was developed by National Instruments ("NI"). Although technical support of this tutorial may be made available by National Instruments, the content in this tutorial may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this content with each new revision of related products and drivers. THIS TUTORIAL IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).