How do I Read or Write to Named Cells or Named Ranges in Excel Using the LabVIEW Report Generation Toolkit?

Updated Feb 5, 2026

Reported In

Software

  • LabVIEW Base
  • LabVIEW Full
  • LabVIEW Professional
  • LabVIEW Report Generation Toolkit

Other

  • Microsoft Excel

Issue Details

As explained in the [External]Create a named range in Excel Microsoft article, it is possible to create named ranges of cells. Now, I would like to modify the properties of this named cell or range programmatically by using the Report Generation Toolkit in LabVIEW. How do I go about doing this?

Solution

 

The Excel Get Data VI lets you pull data from named cells or ranges. On the other hand, the Excel Insert Cells VI, used together with the Excel Easy Table VI, allows you to add data to an existing Excel file. This process is covered in our knowledge base article, Inserting Data to an Existing Excel File Using the LabVIEW Report Generation Toolkit.
For this use case, just wire the name of the cell or range into the Name input terminal of the appropriate VI. You can find this terminal at the bottom of each 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.