writing string into spreadsheet

[crossrulz]

---

@Dennis_Knutson wrote:
User the build array function.

---

Ah.  Now it all makes sense to me.

You are trying to build an array by using a FOR loop.  You are making the loop iterate the number of times as the while loop iteration count.  Then the Write To Spreadsheet File is set to overwrite your file each time you write.  So, since you have looped 6 times, you are making an array of your last recieved data 5 times and then overwriting your file with that.

[nishar10]

my issues s in writing spreadsheet....i was unable to write the serial data properply in ms excel alne...i can write it properly in wordpad...from first my auto indexing is on ..even after that i cant able to write it.....i am expecting a solution zealot.......kudos...................

[Dennis_Knutson]

Did you get rid of that silly for loop? You are writing to Excel with the function so I don't understand your comment.

[muks]

---

@nishar10 wrote:

my issues s in writing spreadsheet....i was unable to write the serial data properply in ms excel alne...i can write it properly in wordpad...from first my auto indexing is on ..even after that i cant able to write it.....i am expecting a solution zealot.......kudos...................

---

Did you try the build array as suggested? Please just mention the input and the output that you expect. That will clear a lot of things

[nishar10]

ya i used build array ...but the data`s are not updating  in spread sheet... my input is a string which is getting from a serial interface device... i have to write it in excel and wordpad... i am writing it properly in word pad...but in spread sheet i cant.i am getting the 1st data once,2nd data twice,3rd data thrice...(1,2,2,3,3,3).goes on.... i need it like this (1,2,3)

[muks]

Why dont you post your vi? First my suggestion is forget about writing the data. See if you are able to get the desired output in array format . Check that in your indicator. You can always write this with no issues.

[Dennis_Knutson]

That does not make any sense. No where are you writing to excel. All that you need its a single file write. The Write to Spreadsheet creates a text file.

[LV_user1]

Whatever data you are getting from serial port (string) you simply need to pass it to build array function(to convert it into array format) and then pass this 1 d array directly to write to spreadsheet function.

Make sure that you have griven "append to file" input as true to write to spreadsheet file function. otherwise data in the file will be overwritten and you will get only last iteration value.

[crossrulz]

---

@nishar10 wrote:

ya i used build array ...but the data`s are not updating  in spread sheet... my input is a string which is getting from a serial interface device... i have to write it in excel and wordpad... i am writing it properly in word pad...but in spread sheet i cant.i am getting the 1st data once,2nd data twice,3rd data thrice...(1,2,2,3,3,3).goes on.... i need it like this (1,2,3)

---

Go back to my post 11 (http://forums.ni.com/t5/LabVIEW/writing-string-into-spreadsheet/m-p/2899578#M840986).  I described exactly what is happening.  Here are the things you need to do to fix it.

1.  Get rid of the FOR loop.  Use Build Array with just 1 input.  You will have a 1D Array with just your one string.

2.  Wire in a TRUE to the Append? input of the Write To Spreadsheet File.