LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to write 4 or more of floating numerics to a spreadsheet?

Write To Spreadsheet.vi only accepts numeric arrays as an input. This is mentioned in the help and should be seen by looking at the inputs themselves. If you open the VI and look at the diagram, you'll see instructions on how to convert the VI to handle string arrays. When you save the changes, do it with a different name and do not save it to the vi.llb folder - otherwise it will be overwritten when you upgrade LabVIEW.
0 Kudos
Message 11 of 14
(708 Views)
Here's your VI back. The problem was that the result of you formatting was a string, and you were trying to connct that to an input that was expecting an array of numbers. All I had to do was change the file i/o routine to one that writes character strings to a file.

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
0 Kudos
Message 12 of 14
(708 Views)
Thanks for your help. I changed the code, but have another problem: the data I save to as spreasheet file is not in one row, the last column becomes the 2nd row. This is really strange! The attached file shows what I meant by that.
0 Kudos
Message 13 of 14
(708 Views)
I figured it out. Thanks!
0 Kudos
Message 14 of 14
(708 Views)