LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I write a string array into a spreadsheet file

I have both string and numerical data that I want to Write to a Spreadsheet.vi. I converted all the numerics to strings and put them in the string array. I now what to write the string array into the Write to Spreadsheet.vi (.xls file) bit that vi only allows 1D or 2D data.

 

Thanks

0 Kudos
Message 1 of 5
(9,131 Views)

Convert your numeric data to string.

Build an array of all strings

Format array into spreadsheet: Format specifier is %s for strings.

Write Characters to File.

 

Felix

0 Kudos
Message 2 of 5
(9,128 Views)
If you got a 3D array out of a build array function, you did not set the build array to concantanate. Right click on the build array and select that option.
0 Kudos
Message 3 of 5
(9,118 Views)
Dennis, That's what I tried and I get a broken wire saying the input and sink data formats are different even after I change the format function to %s. 
0 Kudos
Message 4 of 5
(9,110 Views)
There is no build array and no broken wire in that VI. The use of locals is also silly.
0 Kudos
Message 5 of 5
(9,108 Views)