Search code examples
actionscript-3flashwhitespaceexport-to-excelexport-to-csv

How to switch to another column when exporting to csv

I need to export some data to MS Excel. I laod the data to the ByteArray and then I print it to the file. Nevertheless I wasn't able to find out, how to switch to next column. I tried '\t', "\t", Char(9) and many others, but what I get in excel file is only unknown character symbol ... "\n" works just fine... I'm programming this app in AS3, if it could have any connection..

Solution

  • CSV stands for "comma separated values". The default delimiter for columns is the comma (,).

    Also, you can designate what character you want to use as the column delimiter (tabs, for example), when importing to excel