how we can convert an array into .csv format and save it in .txt file or excel file?

[Guruthilak · Accepted solution]

First of all,

Post the question or the query in the body of the forum not in the heading itself.

You can use the "Array to spreadsheet string " found in the the "programming->Strings" pallete with the required delimiter to convert an array. Then write them to a .txt or excel file

Guru

[smercurio_fc]

Or, you could just use Write to Spreadsheet File. Wire your array directly to it, and it will write out a text file with delimited column. CSV uses a comma to separate column, so if you just specify a comma as your delimiter you'll get a CSV file. These file can be directly opened in Excel without having to resort to ActiveX to create actual Excel workbooks.

[Bill El Sayed]

Thanks very much! it's running!