LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview- Issue Saving Excel files

Highlighted

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
(982 Views)

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

 

e.png

 

-------------------------------------------------------------------
Unfortunately, most readers of this Forum, including some real Experts, have not mastered the skill of being able to read the code that Posters fail to post. If we cannot see "what you did wrong", we are unable to tell you how to fix it. (Bob Schor 28 August 2018)
0 Kudos
Message 2 of 4
(944 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
0 Kudos
Message 3 of 4
(939 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
(907 Views)