LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how do i label columns in excel

Solved!
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
(3,191 Views)

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
(3,184 Views)

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

0 Kudos
Message 3 of 8
(3,167 Views)

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
(3,158 Views)

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
(3,154 Views)

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
(3,150 Views)

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
(3,124 Views)
Solution
Accepted by topic author Elipse

This is what it would look like:

 

Save CSV.PNG

 

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
(3,116 Views)