Showing results for 
Search instead for 
Did you mean: 

how do i label columns in excel

Go to solution

I need to know what code do i use in labview to label the columns in excel when the data is opened up in excel. Thank You

0 Kudos
Message 1 of 8

Convert the 2D DBL array to a 2D string array (using Number to Fractional String) and then use Build Array to add a row of headers to the array. Once you have an array of string, LV will call a VI which saves strings to a spreadsheet file.

Try to take over the world!
0 Kudos
Message 2 of 8

I apologize but I am new to labview can you visually show me. Thanks

0 Kudos
Message 3 of 8

These are the functions I talked about:


Save strings.PNG



This is really very basic, so you're going to have to learn how to do this. I suggest you try looking at some of these tutorials.

Try to take over the world!
0 Kudos
Message 4 of 8

Thank You it worked. However, I do not want it to constantly repeat it. It should only label it once at the beginning of the column.



0 Kudos
Message 5 of 8

Then go back to the way it was before and write the headers to the same file once before the loop. Note that in any case this will only work if the append input is set to T.

Try to take over the world!
0 Kudos
Message 6 of 8

Thank You but I tried to understand what you were saying to the best of my ability without any visual depiction but I still was not able to get it to work where I only have Labview write the column headings once. Also thank you for the link to the beginners guide to Labview.

0 Kudos
Message 7 of 8
Accepted by topic author Elipse

This is what it would look like:




Ignore the fact that I compressed the code in the loop. The important part is that you write the first row once before the loop and the rest of the data inside the loop (with the append input as T).


In general, this is very important to understand on your own if you expect to do anything in LV. I would strongly suggest you follow those tutorials and try learning from other places as well.

Try to take over the world!
0 Kudos
Message 8 of 8