Writing data to spreadsheet continuously

[jeguna]

Hello,
I am having trouble writing data to a spreadsheet.

I have 10 variables (a1, a2,... a10) in a FOR loop, which I want to record in a file. The for loop count is 1000. Can anyone help me with this? Also, is there a way to place the variable names at the beginning of the file to differentiate the columns?

Thanks in advance.

[PauloM]

Hello,

Try this:

Hope it helps,
Paulo

[PauloM]

You'll need this too...

[jeguna]

Hi Paulo,
Can you save it in ver 7.0 and resend it? Thanks

Jeguna

[PauloM]

Here it is.
By the way, I just saved the values in the file after the loop ends, I don't know is that's what you want, but you can still bring it to inside the loop and wire the data to the 1D array input instead of the 2D input.

Hope it helps.

[jeguna]

Hi Paulo,
Thanks very much... it's very close to what I wanted. In my case there is one more FOR loop over this loop. In that case I can't enable the indexing for the external loop.

Any help is appreciated.

[PauloM]

Hi,

Now I'm not following you... you can put another for loop around the for loop in my program (the write to spreadsheet file function must be out of the first loop and in the second)and it will work, because the write to spreadsheet is appending the data and not overwriting, so it will write a block of data after another.

[jeguna]

Thanks Paulo... it works just fine.

Jeguna

[PauloM]

Glad it helped!
Paulo