There are two VIs included with the Report Generation Toolkit, Excel Insert Cells VI
and Excel Get Data VI
which allow you to insert and retrieve data into and from named cells or ranges. Simply wire in the name of the range or cell to the name
input terminal of either VI. This terminal is located on the bottom of each respective VI.
Note that when you insert cells in a named range, you are given the option to either shift the range down or to the right, or enter an entire row/column. Inserting a row or a column will insert cells throughout the entire worksheet, not just in the named range you have selected. If you opt to shift cells down or to the right, only one cell will be entered at the top left corner of the range.