Writing a 1D Array of Cluster to Spreadsheet file

[MogaRaghu]

I need to write to a Spreadsheet data from a Array of Clusters . The cluster has 10 elements in it. 

One way would be to make 10 independent arrays of the elements in cluster and append the array one after the other to the spread sheet ? This looks pretty long winded. 

Any other way to do this ?  Thanks 

[altenbach]

Since your cluster is mixed (I32 and U32), you need to convert to a datatype with a range that covers both. (DBL, I64, etc). Depending on the desired output, transpose the 2D array.

(If you have more information, e.g. you can guarantee that there are no negative values and nothing over 2^31, further simplifications are possible.)

(Why are some elements named "Byte" if they are not U8? Seems confusing! If they are guaranteed to be in the range 0...255, toU32 would be sufficient above)

[altenbach]

All your values seems to be small positive integers, so U32 should be plenty:

[MogaRaghu]

Wow. That looks simple … never thought of the conversion. 

the reason the ID and milli are 32 bit is that they are CAN bus data. 

thanks for the prompt help !!