Data format problem with Write to Spreedsheet File

[powerplay]

I have a problem with the data format with Write to spredsheet file.

I have an N*3 array, where the 3 elements in each row should has different length. When I used Write to spreedsheet file,

it can only save the three data in one format. How can I save them in the format of "%0.8f %0.3f %0.2f"?

Thanks for your help.

[GerdW]

Hi powerplay,

WriteToSpreadsheet is made for generic purposes. If you need something special, you have to program something special...

Make a for loop to auto-index through your array, use a FormatIntoString inside the loop to format the values. Either append the strings in the loop or use autoindexing andArrayToSpreadsheetstring afterwards...

[elset191]

I believe the same issue was presented here

[powerplay]

Thank GerdW and elset191. TO elset191, my question is different from that posts. I have a specific l...

[GerdW]

Hi powerplay,

another solution may be to convert column-wise using "number to fractional string", then interleaving resulting arrays and again using "array to spreadsheet string" (with "space" as separator).

Many ways lead to Rome