For example, if you used the Excel Easy Table VI you would wire this Position to the Start (0,0) terminal. Use this Position as the input start position for the VI you will use to insert the data.Use an Unbundle By Name function to extract the Position of the last row and column from this cluster.

This VI will return a cluster that includes the position of the last row and column. You can programmatically append data to your existing Excel file by first using the Excel Get Last Row VI to get the position of the last row and column in the Excel file.In this example a 2D string array is being written as data via the Excel Easy Table.vi. For example, if you used the Excel Easy Table VI, you would wire your desired start values to the Start (0,0) terminal. Use the same start values used for the Excel Insert Cell VI for the start position input terminal of the VI you will use to insert the data.Select where the new cells will be placed and then use other Report VIs to insert your data into this space. Use Excel Insert Cells VI to add new cells, rows, or columns to your Excel file depending upon the amount of data you will add. To insert data at the beginning or middle of your file you need to first add new space in which to place the data.This will open your existing Excel file and any subsequent Report VIs will modify the existing file.

Configure LabVIEW to open an existing Excel file by using the New Report VI with Excel as the report type and the file path of your Excel file as the template.

To append to the beginning or middle of an Excel file:

Use excel labelview 2015