[CTJUG Forum] Re: CSV files

[Ewald Horn]

Hi Ryan,   CSV files contain no formatting information,  even the test I created failed to load correctly until I double-clicked on the cell to edit it. You simply write a $0A character wherever you want the new line to appear. Here's some sample code for you to look at. It's not perfect but it works for me.   // code start import java.io.*;   public class WriteCSV {       public static void main (String args[])     {    try  {      DataOutputStream outFile = new DataOutputStream (new FileOutputStream ("mytest.csv"));        for (int lines = 0 ; lines < 5 ; lines++)      {   outFile.writeBytes ("Test data line,\"");     for (int i = 0 ; i < 5 ; i++)   {       outFile.writeBytes(Integer.toString(i));       if (i < 4)    outFile.writeByte (10); // $0A   }     outFile.writeBytes ("\",1,2,3,4,5");   outFile.writeByte(13); // $0D   // write $0D0A sequence for a new line   outFile.writeByte(10);  // $0A      }    }  catch (Exception e)  {      // Sample code, lets hope nothing goes wrong  }       } } // code end     I hope this helps.   Kind regards Ewald Horn Business Manager NoFuss Solutions South Africa Cell : 083 519 1615 Web: www.nofuss.co.za Custom software development --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CTJUG Forum" group. To post to this group, send email to CTJUG-Forum@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/CTJUG-Forum For the ctjug home page see http://www.ctjug.org.za -~----------~----~----~----~------~----~------~--~---