Write to spreadsheet file

[Veeru]

Hi

I need help in write to spreadsheet,I want to save data from the euipment.

for example i need to save values in some different columns.Lets say the 1st coulmn needs to come in loop so it increments by1 everytime.accordingly in the 2nd column i need to get the values for each element of the 1st column.

Thanks

[MikeS81]

Hi Veeru,

do you mean you want two columns with the same values? You can use the "build array" function and then the "transpose 2d array".

Mike

[Pnt]

There are examples shipped with Labview.

Also it has been discussed many times. Do a little search on the forum.

If you still need help... post again

[Veeru]

Thanks Mike and pnt

Mike,i need different values in two columns

Thanks

[MikeS81]

Hi Veeru,

do you have your answer now, or is there still something inoperable?

Mike

[Veeru]

Still not able to get it

[MikeS81]

Hi Veeru,

see the attached picture. It shows how you can create to columns and write theme to the spreadsheet file.

Mike

Message Edited by MikeS81 on 05-29-2008 01:47 PM

[Ray.R]

Hi Veeru,

If you have two types being written to two columns, then you can either write one line at a time (for instance while collecting results), or have two seperate 1D arrays being written to the entire column at once.

The trick is the indexing.  If you look at some examples, look at how the columns and rows are indexed.  Since column is 1, the values for columns would be something like startCol & starCol+1.  Same process for the rows.  Find out how many row elements you have and add it to the srating row.

If you write multiple times, such as 1 row at a time, keep track of the last row number.  Add 1 before writing to it again so that it goes to the next one.

RayR

EDIT:  I just read Mike's reply...   Sorry... For some reason, I thought this was for an Excel Spreadsheet.  Ooops.  My bad.. 😮

Message Edited by JoeLabView on 05-29-2008 07:49 AM

[Veeru]

Thanks Mike

I will try it and let u know

Once again thanks very much