LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview- Issue Saving Excel files

I am looking to streamline the way we are saving our data, and I have been having some trouble with the write to measurement file block. What we have been doing is right clicking on the waveform plot and exporting to Excel and then saving that file as shown below. This method has been working for us, however it can be time consuming to export and save.

Process1.JPG

 

 I have tried using the write to measurement file block, and it does save the excel file to the designated folder. The problem is that the time seems to be limited to three decimal places. The waveform plot is set to 7 sig figs so when I export I can pick up the smaller time step shown above.

 

Process2_Write to measurement.JPG

 

When I open up the write to measurement block I am only able to set the seconds time stamp to the third decimal place. If I add any additional zeros to the code, the saved excel file is corrupted and has to be restored. If anyone has any advice it would be greatly appreciated.

Process2_Save_to_Measurement.JPG

0 Kudos
Message 1 of 4
(3,175 Views)

Have you tried using the "Write to Delimited Spreadsheet" VI?

 

e.png

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 2 of 4
(3,137 Views)

@RTSLVU wrote:

Have you tried using the "Write to Delimited Spreadsheet" VI?


Or since we are already dealing with Waveforms, use the Export Waveforms To Spreadsheet File.

 

Probably the better option is to log to a TDMS file and then use the Excel Add-On to read the TDMS file.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 3 of 4
(3,132 Views)

Yea I switched the data type to TDMS, and it looks like I am getting the correct time data. The end goal is to be able to run this data through a Matlab script and it looks like they have add-ons to read these files.

0 Kudos
Message 4 of 4
(3,100 Views)