string and number into a speadsheet

[Sai Kit]

Dear all,

I have a simple question. I need to store numbers and strings into a file. The ideal format is excel file. I could save it in txt file with tab separating each column, and then change the format myself.
I can construct a 2D string matrix, which stores all the information I need. However, I don't know how to store it. I try to use save speadsheet vi, but it doesn't work for me. Is there anyway I can save the data as a table and then use it in excel?

Thanks
Sai Kit

[chilly_charly]

---

@Sai Kit wrote:
I need to store numbers and strings into a file. The ideal format is excel file. I could save it in txt file with tab separating each column, and then change the format myself.
I can construct a 2D string matrix, which stores all the information I need. However, I don't know how to store it. I try to use save speadsheet vi, but it doesn't work for me.

---

You probably missed a single step before saving in a file : use the Array to Spreadsheet function (in the string sub-palette) to convert your 2D string array into a single string with tab/return delimiters, then use the Write Characters to File vi. BTW, you could use a Table as 2D string array.
CC