arrray of strings into spreadsheet

[Mandya]

hi,

Pls help me in writng the array of strings into spreadsheet (.xls)

I have 3 or 4 different 1d array of strings and i have to put each array of string into differnet coloumn....

thanks

[crossrulz]

Does it have to be an actual xls file or will a CSV (which can be read directly from Excel) file do?

If a CSV will work, combine all of the arrays into a 2D array.  You will likely need to use Transpose 2D Array.  Then use Array to Spreadsheet String with a comma as the delimiter.  Write the new string to a text file.

[apok]

[crossrulz]

Just be warned.  If you follow the advice given and you give the file an extension of xls, you will get an error when opening the file in Excel.  This is not saving in an xls format.  I would recommend using csv as an extension.

[apok]

---

@crossrulz wrote:

Just be warned.  If you follow the advice given and you give the file an extension of xls, you will get an error when opening the file in Excel.  This is not saving in an xls format.  I would recommend using csv as an extension.

---

true....change the extension to .csv and put a comma into the delimeter

[Mandya]

thanks for your reply.

I am reading each string form Xml and trying to put into spreadsheet

ex:

rite now i am putting each sting into indivisual string and displaying but i need these string should be transfered to array

Arrray 1 contians "sam" should write into coloumn 1 in spreadsheet.xls

Arrray 2 contians "tom" should write into coloumn 2 in spreadsheet.xls