Array to Spreadsheet String VI truncating my rows

[mechEmike]

I'm using Labview 8.0.

In my VI I am feeding the "Array to Spreadsheet String" VI an array of strings that are in the following format.

7/09/2010 7:43:23.27472 95.284953

7/09/2010 7:43:23.27572 95.284953

7/09/2010 7:43:23.27672 95.284953

7/09/2010 7:43:23.27772 95.284953

       :             :                     :

The first entry is the data, then time, then data.

The problem I am having is that when I pass this array of strings through the "Array to Spreadsheet String" VI it cuts off the entries and I get the following:

07/

07/

07/

07/

:

The format I feed to the VI is <%s> for string. Any help would be great. Thanks!

[GerdW]

Hi Emike,

for me this works:

[aeastet]

Do you have a screen shot of your code? I took the arry that you gave and I can get it to export with no problems.

[mechEmike]

Here is the screenshot. The GUI is in the upper portion of the screen so you can see what the outputs are. Thanks.

[GerdW]

Hi Emike,

again no problem:

[aeastet]

[mechEmike]

I'm still having an issue. I am thinking it might be in the way I am building my array that I pass to the Write to Spreadsheet VI. Here is a screen shot of the code that builds the array. 

[mechEmike]

That function you suggest take a spreadsheet string and converts it to an array. But my data is already in an array form and I need it in a spreadsheet string form. When I tried it, I get terminal source compatibility issues.

[aeastet]

You are building a string not an array. You need to replace the concatinate string with a buil array and get a 2D array not a string for this to work properly.

[mechEmike]

It is almost working now. I get both the time and the data, but the problem is that the Array to Spreadsheet String function is only letting through three characters from each column.