ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

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,362 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,359 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,349 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,341 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,339 Views)