LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Data recording excel or text file

Is there a way to select some variables from a VI and save the values from those variables alone in an excel file? 

 

When saving data to excel or for that matter a text file, is there a way to get the data label as a header in the excel/text file? 

 

I have an application where the variables I record from the same program are different each time. If I use the write to file feature, I have to manually type my header. 

 

Seems to me that there has to be a easier way to do this. 

0 Kudos
Message 1 of 12
(3,931 Views)
What data label are you talking about? Is it something you read from an instrument?
0 Kudos
Message 2 of 12
(3,922 Views)

Dennis,

 

It can be data aquired from an instrument or data displayed as a result of a calculation in LV.

 

I am posting the VI tht I am using right now. 

 

There is a place where I have to manually type the header information. Suppose if the data I am recording was from an instrument, this will be a tag id. 

 

 

0 Kudos
Message 3 of 12
(3,898 Views)
Tags can be easily written to a file. It's just a string write. You could write columns with a single Write to Spreadsheet File and the Data with another.
0 Kudos
Message 4 of 12
(3,884 Views)

But I will still have to "type" manually the string right? 

0 Kudos
Message 5 of 12
(3,879 Views)
If you read the string from something, like you said, you would not have type anything. I asked where the label came from and you said it was coming from an instrument.
0 Kudos
Message 6 of 12
(3,872 Views)

Yes. Although not all tags come from an instrument. 

 

There are calculated data that I would like to store also in the excel/text file.

 

How can I write the label of the data onto the excel/text file ?

0 Kudos
Message 7 of 12
(3,867 Views)
There is no name associated with a wire. You can label a wire. Is that what you want to extract?
0 Kudos
Message 8 of 12
(3,861 Views)

I want to extract the label of an indicator/controller 

0 Kudos
Message 9 of 12
(3,853 Views)
You simply use a property node to get the text of the label or caption.
0 Kudos
Message 10 of 12
(3,840 Views)