Use a Control Label as Spreadsheet Header in LabVIEW

Issue Details

• Is it possible to use the label of a LabVIEW Control as a header in a spreadsheet?
• Using LabVIEW, how can I create headers for columns in my spreadsheet?

Solution

The labels for each Control can be use to create headers for spreadsheets.

In order to do this, please follow the steps below:

1. Right-click the Control that you wish to use to create a header, and select Create>>Property Node>>Label>>Text.

2. Once your Property Node has been created, wire the output to a Build Array function.
3. Then, wire the output of the Build Array function to the 1D data input of the Write Delimited Spreadsheet VI.

4. Now that your spreadsheet has headers, you can add the data in your spreadsheet. Below is an example where ten numbers are randomly created and stored in the Test1.txt file under the header Label-1.

Additional Information

The code shown above can be implemented using multiple headers. Below is an example using two headers for ten numbers randomly created and stored in the Test2.txt file under two headers.