LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Append 1D Array of strings to spreadsheet

Solved!
Go to solution

This is killing me! 

I have an existing .csv file with header.
I want to add a row of text data(append) and repeat onto the next row when needed.
Seems to me I used to just wire my 1D array of strings to the 1D input of the Write to Spreadsheet.vi but that functions seems to have disappeared

Download All
0 Kudos
Message 1 of 11
(3,367 Views)

Write delimited spreadsheet gives you all the functionality you need.

 

Write.png

0 Kudos
Message 2 of 11
(3,357 Views)

I thought so too but for some reason my write to spreadsheet does not allow 1D input

0 Kudos
Message 3 of 11
(3,346 Views)

There is a 1D Data input to the Write Delimited Spreadsheet VI.


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 4 of 11
(3,337 Views)

Not on mine!

This is what is driving me nuts. I've used that function numerous times but at the moment the is ONLY a 2D option.

If I right click the icon and select Automatic input it still rejects my 1D input.

0 Kudos
Message 5 of 11
(3,328 Views)

I just tried it in LV2016 and it works as it is suppose to.

I think the problem is with LV2019

0 Kudos
Message 6 of 11
(3,318 Views)

There should be two inputs, one for 2D and one for 1D right below it.

 

If you don't see that, double-click the function (it's just a plain VI under the hood!) and see if somebody modified it. In that case, you might have to reinstall LabVIEW.

0 Kudos
Message 7 of 11
(3,316 Views)

Hi Murph,

 

attach your version of WriteDelimitedFile.

What is the path to that function? Did you accidently change/overwrite that function despite it is in the VI.lib?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 8 of 11
(3,314 Views)
Solution
Accepted by Murph

@Murph wrote:

I think the problem is with LV2019


Mine works fine in LabVIEW 2019, so check my message above (here's the picture from the 2019 context help)

 

WriteSome.png

Message 9 of 11
(3,310 Views)

I went in to look at it and YES, it had been modified.

Looks like I was able to add it back and it appears to be working.

 

THANKS

0 Kudos
Message 10 of 11
(3,305 Views)