Send Additional Data to Microsoft Excel
In Figure 1, the Lesson 1 VI represents the VI you built in the first part of this tutorial, which teaches you how to open Excel, create and rename worksheets, and add data to a worksheet. You can manipulate the data from that VI by adding additional data to the worksheet, sorting the data in Excel, inserting functions across a range of cells, and running a macro function in Excel.
Figure 1. Adding Additional Data to an Excel Worksheet
Suppose you initiate a second test on the widget UUT and need to post additional data to the Excel worksheet. Because you need to post only numeric data to the Excel worksheet, you can use the Excel Easy Table VI included with the toolkit. You can use this VI to format and post the data to Excel in one step.
Sort Data with Microsoft Excel
As shown in Figure 2, if you want to sort the data on the worksheet from lowest to highest values, you can use the Excel Sort Data VI to access any of the available sorting methods already found in Excel. This example sorts each column of data separately using a For Loop, which scales the worksheet as testing needs change.
Figure 2. Sorting Each Column of Data Separately
Figure 3 shows the sorted results of the worksheet.
Figure 3. Data Before and After Using Excel Sorting Method
Insert Data and Run Macros
You can use the toolkit to add functions to a range of cells with minimum data entry. Using the Excel Insert Formula VI in Figure 4, the VI enters the formula one time for the cell range B7:B17. If you apply the formula to a range of cells with the same VI, the values automatically update to reflect the new data ranges. You can use the Excel Get Excel Location VI and the Excel Set Excel Location VI to place data at specific locations within an Excel worksheet.
Figure 4. Inserting a Function and Running a Macro
If you already developed data manipulation code in Visual Basic or worksheet formatting instructions in the form of Excel macros, you do not have to redo this work. You can use the toolkit to load Visual Basic modules as macros and to run predefined macros on a worksheet, reusing any existing code already developed in Excel. The previous example uses the Excel Run Macro VI to apply some simple formatting to the data. The final results of this example look similar to Figure 5.
Figure 5. Test Data Sorted and Formatted with a Macro in Excel