title: Android export data to csv
body: <p>I want to export some fields from a table in my SQLite database in <code>CSV</code> format. I'm using the library <code>opencsv-2.4</code>. 
  Works, but all the columns of the table are stored in a single column of the spreadsheet instead must be separated. 
  This is my method:</p>
  
  <pre><code>  File exportDir = new File(Environment.getExternalStorageDirectory(), "");        
  if (!exportDir.exists()) 
  {
      exportDir.mkdirs();
  }
  
  File file = new File(exportDir, "csvname.csv");
  try 
  {
      file.createNewFile();                
      CSVWriter csvWrite = new CSVWriter(new FileWriter(file));
      SQLiteDatabase db = mHelper.getReadableDatabase();
      Cursor curCSV = db.rawQuery("SELECT * FROM Table",null);
      csvWrite.writeNext(curCSV.getColumnNames());
      while(curCSV.moveToNext())
      {
         //Which column you want to exprort
          String arrStr[] ={curCSV.getString(0),curCSV.getString(1), curCSV.getString(2)};
          csvWrite.writeNext(arrStr);
      }
      csvWrite.close();
      curCSV.close();
  }
  catch(Exception sqlEx)
  {
      Log.e("MainActivity", sqlEx.getMessage(), sqlEx);
  }
  </code></pre>
  
  <p>}</p>