topic Re: Array to Spreadsheet String VI truncating my rows in LabVIEW

Array to Spreadsheet String VI truncating my rows

mechEmike — Fri, 09 Jul 2010 13:45:15 GMT

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/

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

Re: Array to Spreadsheet String VI truncating my rows

GerdW — Fri, 09 Jul 2010 13:48:45 GMT

Hi Emike,

for me this works:

Re: Array to Spreadsheet String VI truncating my rows

aeastet — Fri, 09 Jul 2010 13:52:41 GMT

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.

Re: Array to Spreadsheet String VI truncating my rows

mechEmike — Fri, 09 Jul 2010 14:01:34 GMT

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

Re: Array to Spreadsheet String VI truncating my rows

GerdW — Fri, 09 Jul 2010 14:09:03 GMT

Hi Emike,

again no problem:

Re: Array to Spreadsheet String VI truncating my rows

aeastet — Fri, 09 Jul 2010 14:16:47 GMT

Re: Array to Spreadsheet String VI truncating my rows

mechEmike — Fri, 09 Jul 2010 14:23:09 GMT

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.

Re: Array to Spreadsheet String VI truncating my rows

mechEmike — Fri, 09 Jul 2010 14:30:48 GMT

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.

Re: Array to Spreadsheet String VI truncating my rows

aeastet — Fri, 09 Jul 2010 14:34:02 GMT

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.

Re: Array to Spreadsheet String VI truncating my rows

mechEmike — Fri, 09 Jul 2010 15:04:17 GMT

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.

Re: Array to Spreadsheet String VI truncating my rows

aeastet — Fri, 09 Jul 2010 15:06:35 GMT

Sounds like a different problem. Can you show what you are seeing?

Re: Array to Spreadsheet String VI truncating my rows

Darin.K — Fri, 09 Jul 2010 15:22:55 GMT

I only have hints, but let me take a completely wild guess.

1. You are using an old version of LV

2. You have modified the Write to Spreadsheet File VI to accept strings by following the suggestions on the BD

3. There is a format string inside your modified VI which is truncating the strings (ie %.3s)

Re: Array to Spreadsheet String VI truncating my rows

Dennis_Knutson — Fri, 09 Jul 2010 15:29:09 GMT

He did have to modify the function and the instructions do instruct you to change the default %.3f.

Re: Array to Spreadsheet String VI truncating my rows

Darin.K — Fri, 09 Jul 2010 15:47:51 GMT

I was about 99% sure when I saw the screenshot with the old VI taking a string array, along with the fact that the default used to be %.3f. Now I am at least 99.9% sure.

I'll modify my guesses as follows:

2. You have modified the Write to Spreadsheet File VI to accept strings by following most of the suggestions on the BD

Now I am up to 99.99% sure.

Re: Array to Spreadsheet String VI truncating my rows

mechEmike — Mon, 12 Jul 2010 16:45:24 GMT

Got it. The format value that I thought I had changed was reverting to the default %.3f each time I ran the program. Thanks for all the help!