Saving data in excel problem

[Alexander J.]

Hi all,
I have a problem in saving my data into excel file. What I am trying to do is, when I run my VI, I want to save my data into excel. Then I run again, I want to append to file by column. Not by row. Think you guy understand. I attach one file what I trying to do. Please take a look. Thanks.
Saw

[BrandonS]

I am not aware of an easy way to do this, but I have done this in the past. What you can do is read in the spreadsheet file every time you run the VI. Do the following with the data:
1. Read From Spreadsheet File VI
2. Transpose 2D
3. Wire Transposed 2D data to the top terminal of a build array
4. Wire new 1D array data to the bottom termainal of a build array
5. Transopse 2D data again
6. Write this 2D data back to the same spreadsheet file using the write to spreadsheet file VI.

There might be easier ways, but this is a way I had previously done.

[rkanders]

You have to specify range for data destination. Column would be Range("A1,A3"), Row would be Range("A1,C3"). Get excel toolkit from this website and see how it is done for 2D array and then you can modify it for 1D column vector. Toolkit is for free, submit by Phlips Research, I think.

RK

[Alexander J.]

Thanks RK.
Saw