write array to spreadsheet string

[jyang72211]

Hi,

I have 3 numeric arrays and 1 string array.  I am try to use the function write array to spreadsheet string.  What is the easy way to do this, since I have both numeric and string, I can't create a 2d array directly?

Yik

[PhillipBrooks]

You can pass your 2-D array of numbers into the Number to Fractional String function. This function accepts scalar, 1D and 2D arrays as input and creates an equivalent output array.

Use the array functions to combine the converted numbers and the string array into a single array, then pass this combined data to the write spreadsheet function.

[Ray.R]

The easiest way would be to write twice to the spreasheet string. 

Once for your string array and once for your numeric array, in the order you want the data to appear.

Make sure you append to the spreadsheet string when writing the second array.

[altenbach]

You would first turn the numeric array into an array of strings (e.g. using "Number to fractional string"). Now all match. 🙂

[Dennis_Knutson · Accepted solution]

This is pretty basic and a commonly asked question. First convert the numeric arrays to string arrays. The numeric/string conversion functions are polymorphic so you can connect a 1D or 2d array to the input.

[altenbach]

So, within minutes you got four very different and conflicting answers ... 😮

(just kidding, they all are basically the same! :))

[Ray.R]

It depends how you want the file to store the data.

Attached is an example of two methods mentionned above.  You can change the formatting so that you have the data on the same line or different lines.

There are many solutions depending on exactly what you want to accomplish.

--- didn't expect to see so many replies so quickly ---

Most people recommend converting the numeric array to string array first.  I offer an alternative 😉  or a choice of both..  😄

[jyang72211]

Nice, thanks!

[Ray.R]

The example I did was a bit hasty.  Here's the corrected version.

And I agree with Dennis' solution, which is the example in the middle of the block diagram (sampleData3.txt).

[differential equation]

Dear sir,

I am also facing this similar problem and the main problem being faced is with giving path to the spreadsheet..Is there some link for some tutorial where i can read on this.