Here is the code please suggest me how to export csv from existing db, I have already added "opencsv-2.3.jar" to the project java build path but still shows below error.
LogCat: 10-05 23:20:31.482: E/AndroidRuntime(15756): Caused by: java.lang.ClassNotFoundException: Didn't find class "au.com.bytecode.opencsv.CSVWriter" on path: DexPathList[[zip file "/data/app/eom.ecollector-2/base.apk"],nativeLibraryDirectories=[/vendor/lib, /system/lib]]
public class ExportCsv extends Activity {
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.import_database);
//Button btnExport;
SQLiteDatabase db = this.getDB();
//File dbFile = getDatabasePath("odsr.db");
// DataBaseHelper DBob = new DataBaseHelper(MainActivity.this);
File exportDir = new File(Environment.getExternalStorageDirectory()
.getPath(),+"/Database/");
if (!exportDir.exists())
{
exportDir.mkdirs();
}
File file = new File(exportDir, "Filename.csv");
try
{
file.createNewFile();
CSVWriter csvWrite = new CSVWriter(new FileWriter(file));
//SQLiteDatabase db = this.getDB();
String Table_Name = "RECORDS";
Cursor curCSV = db.rawQuery("SELECT * FROM "+Table_Name, null);
//int c = curCSV.getColumnCount();
csvWrite.writeNext(curCSV.getColumnNames());
while (curCSV.moveToNext()) {
String arrStr[] = { curCSV.getString(0), curCSV.getString(1),
curCSV.getString(2),curCSV.getString(3), curCSV.getString(4),
curCSV.getString(5),curCSV.getString(6), curCSV.getString(7)};
csvWrite.writeNext(arrStr);
}
csvWrite.close();
curCSV.close();
}
catch (SQLException sqlEx) {
Log.e("ExportCsv", sqlEx.getMessage(), sqlEx);
}
catch (IOException e) {
Log.e("ExportCsv", e.getMessage(), e);
}
}
private SQLiteDatabase getDB()
{
String DB_NAME = "odsr.db";
return openOrCreateDatabase(DB_NAME, SQLiteDatabase.OPEN_READWRITE, null);
}
}
Aucun commentaire:
Enregistrer un commentaire