LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to record seconds in LabVIEW and display it in Excel file

Hi,

 

My 6 sensors' output goes to individual "Set Dynamic Data Attributes" and then from there 6 different signals go to "Write to measurement file". When I start the run, I got 6 readings in Excel but now I am missing time (in seconds). May I know how can I include time (seconds) in my coding so that the time display in an Excel file? 

 

Thank you!

Picture.jpg

 

0 Kudos
Message 1 of 7
(1,039 Views)

@Yeun wrote:

Hi,

 

My 6 sensors' output goes to individual "Set Dynamic Data Attributes" and then from there 6 different signals go to "Write to measurement file". When I start the run, I got 6 readings in Excel but now I am missing time (in seconds). May I know how can I include time (seconds) in my coding so that the time display in an Excel file? 

 

Thank you!

Picture.jpg

 


A picture of 7 express vis gives us nowhere near enough information to help you.  We simply cannot see any of the evil express vi configurations. 

 

Attach your vi or a snippet created by selecting the all of the express vis and "Create snippet from Selection" under the Edit Menu. 


"Should be" isn't "Is" -Jay
0 Kudos
Message 2 of 7
(1,014 Views)

"Write to measurement file" has options for a time column (default is empty). What are your settings there?

 

altenbach_0-1680356923214.png

 

Any why are you bothering with excel? Would be so much easier to stream to a tab delimited text file after writing the headers once.

0 Kudos
Message 3 of 7
(1,010 Views)

@altenbach wrote:

"Write to measurement file" has options for a time column (default is empty). What are your settings there?

 

altenbach_0-1680356923214.png

 

Any why are you bothering with excel? Would be so much easier to stream to a tab delimited text file after writing the headers once.


<Age Shaming Mode>

How to teach an old dog a new trick.

 

"CA, TDMS...TDMS...TDMS...HERE! like THIS! TDMS."

"That's it CA, GOOD CLA!" Gives CA Kudos...

"TDMS, CA , TDMS!" Gives Kudos

 

</Age Shaming mode> 

 


"Should be" isn't "Is" -Jay
0 Kudos
Message 4 of 7
(998 Views)

Well, they could just keep everything "as is" and generate a time scalar, give it a name attribute ("time") and build it into dynamic data to be merged with the dynamic data from the other 6 data points. Cringeworthy!

0 Kudos
Message 5 of 7
(985 Views)

@altenbach wrote:

Well, they could just keep everything "as is" and generate a time scalar, give it a name attribute ("time") and build it into dynamic data to be merged with the dynamic data from the other 6 data points. Cringeworthy!


No CA, TDMS!  (no Kudos)


"Should be" isn't "Is" -Jay
0 Kudos
Message 6 of 7
(979 Views)

Obviously they want Excel, so why change the topic?

 

(Unless you are also talking about the excel plugin) 😄

0 Kudos
Message 7 of 7
(976 Views)