Export database into csv

Export database into csv

 
 
  • add permission in manifest
public void exportCsv() { File folder = new File(Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOCUMENTS).toString() + "/" + "SQLiteBackup"); boolean isFolderCreated = false; if (!folder.exists()) { isFolderCreated = folder.mkdir(); } String filePathAndName = folder.toString() + "/" + "SQLite_Backup.csv"; try { //write csv file FileWriter fw = new FileWriter(filePathAndName); for (int i = 0; i < itemList.size(); i++) { fw.append("").append(String.valueOf(itemList.get(i).getFoodID())); fw.append(","); fw.append("").append(itemList.get(i).getFoodName()); fw.append(","); fw.append("").append(String.valueOf(itemList.get(i).getImageId())); fw.append("\n"); } fw.flush(); fw.close(); } catch (Exception e) { Toast.makeText(this, e.getMessage(), Toast.LENGTH_SHORT).show(); Log.e("====", Objects.requireNonNull(e.getMessage())); } }