First create a new report reference using the New Report VI and specify the type of report, which is Excel. When opening a new report, you can use a template from an existing Excel file. Then rename the first worksheet to Sprockets - 2-28-2002 using the Excel Rename Worksheet VI, as shown in the following example.
Figure 1. Opening an Excel File and Creating WorksheetsAdd a second worksheet to the report to track widget production using the Excel Add Worksheet VI, and repeat the renaming process. These four VIs run Excel, load a new Excel file, and rename the worksheets, as shown in the following example.
Figure 2. Microsoft Excel File with Worksheets
Use the Excel Get Worksheet VI to navigate between different worksheets. In the previous example, the last worksheet you created is active and you can use this VI to return to the worksheet Sprockets - 2-28-2002. You can add the results of a UUT test to the worksheet using the Append Table to Report VI. You can use this to enter the data as a 2D text array. In this format, numeric and text data is entered simultaneously, and Microsoft Office-specific formatting information passes to Excel.
Figure 3. Adding Test Data to a Worksheet in Microsoft ExcelBy opening Excel, renaming and adding a worksheet, and appending a table of data to an Excel worksheet, you can create a report of test data similar to the following example.
Figure 4. Test Data Written to an Excel Worksheet
The test data in Figure 4 might not be processed or formatted sufficiently for a professional report or presentation. In the next part of this tutorial, you learn how to manipulate the data in Excel, including sorting data and averaging data sets, and format the layout of the results table.
Collaborate with other users in our discussion forums
A valid service agreement may be required, and support options vary by country.