how to store a 1D array in column format

[Rajavel]

hi..i am new user of labview..my Q is how to write  1D array in column format?? i am using write to spread sheet VI..attached the screen shot..

i have used and removed  the \t demiliter and also used and removed transpose option..answers arr very much appriciated..thanks

[Kumar_B]

If you need to write 1D array in column format into the file just use "\n" or "\r\n"as a delimiter in write to spread sheet File function.

-Kumar.B

[Ray.R]

Simply set transpose to TRUE on "Write to Spreadsheet file.vi".

See below:

[Rajavel]

Hi Ray..thanks for the help..now i am getting similar kind of error but again, its related to 1-D array..

the error is attached in pics..i appriciate the ur kind help..thanks...

[leumaseoj]

You have to understand the data types(Array and Cluster). The subvi power's output is cluster datatype... The output you connected is array.

So you cannot connect...

[Rajavel]

thanks..i understand..now, how to write the cluster data in excel?? which option i have to choose......

[leumaseoj]

I saw your code.

Only 3 cluster elements are there inside. So you have to unbundle it. using property node you can convert it into string and built as a array send it to the spreadsheet.

[leumaseoj]

I post one simple vi. Try it. It is not a ideal way. so many ways are there.

For cluster. i use multiple data type cluster.

Check it out...

[Rajavel]

thank you for ur kind help and time..much appricated...

[Rajavel]

.vi is not opening..i am having 8.2 and the vi is written in version 9..:(..