errors in write to spreadsheet

[miaibis]

I am having problems getting an array to write to a spreadsheet. I am working on a simple data acquire, average, print to excel VI. I have not gotten an error yet, but it will write various numbers. 3.399 is its favorite. It also writes a set of numbers around 3.5 or just creates files that are 0 bytes in size. Anyone else had this problem before?

[Dr._Imad]

post your vi and someone will look at it

[miaibis]

here is my VI. The problem is in the 3rd block of the flat sequence structure.

Also this application is running on a remote PXI with LabVIEW RT. Right now I am saving my data to the PXI.

[THailey3]

Hi Miaibis,

I don't think the problem is in the 3rd block. I replaced the DAQ section of code with known values (a for loop to produce a '0,1,2,3' array) and they are being correctly written to the dab-delimited txt file. Note- the Write to Spreadsheet file.vi writes values to a tab-delimited txt file and NOT an xls file. However, the tab-delimited txt file can be opened in Excel. Another thing to point out is that you should be using Local variables instead of "value" property nodes. Local variables are more memory efficient and reliable.

Hope this helps,

[miaibis]

Travis,
Thanks for looking at my VI, I tried the constant arrays which didn't work properly. I then went through and changed all of my property nodes to local variables. This solved the problem and it works as designed now. Thank you again for your help, switching to local variables isn't something I would have ever thought of.

Miaibis

[chusta]

I am writing a program that retrieves logged data (lvm file) in graphical format using the read Labview measurement file.vi.

I have since decided to retrieve the data in spreadsheet format so i used the Write to spreadsheet file.vi.

it works but the problem is that the vi only retrieves the first 10 samples of the logged data and ignores the rest

how can i be able to retrieve all the logged data?

please help