LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write Delimited to File without the actual function

Solved!
Go to solution

Hey guys, looking to continuously write data to a spreadsheet. I know the Write Delimited to File would work well here, but I am using 2014 version and do not have. How could I code my VI to do this? It is attached.

0 Kudos
Message 1 of 4
(939 Views)

I think you can use Array to spreadsheet String to convert 2D array into string , then just use write file. 

 

Message 2 of 4
(915 Views)
Solution
Accepted by topic author parker300

I use the file primitives these days because this method has a couple advantages.

  1. It opens the file once and closes the file once
    1. This has a performance advantage over Write to Delimited Spreadsheet because that VI opens and closes the file on every write
  2. Having the file open prevents users or other program from opening the file while the LabVIEW program is running.
    1. Windows will Lock the file access preventing a Sharing Violation that will crash your LabVIEW if someone open the file between writes while using Write to Delimited Spreadsheet

wtfCapture.PNG

========================
=== Engineer Ambiguously ===
========================
Message 3 of 4
(910 Views)

@parker300 wrote:

Hey guys, looking to continuously write data to a spreadsheet. I know the Write Delimited to File would work well here, but I am using 2014 version and do not have.


The old version of the Write Delimited Text File was the Write To Spreadsheet File VI.  But since you are continuously writing data, use the primitives as already stated.  Use Array To Spreadsheet String to convert your data into a string and then write that string with Write To Text File.  Open/Create the file before your loop and close it after the loop.


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
Message 4 of 4
(878 Views)