SQLiteToExcel - v1.0.0

SQLite2Excel
SQLiteToExcel is a Light weight Library to Convert SQLite Database to Excel. I have Released Newer Version for this Library. If your Requirement is only to export your SQLite Database, then this library is very much suitable. Otherwise you requirement is to import or export excel to db or vice-versa, then you go for my newer release. Please visit here to see about SQLite2XL Version 1.0.1

How to Download

add the following library in your app level gradle file
compile 'com.ajts.androidmads.SQLite2Excel:library:1.0.0'

How to Use

1.AndroidManifest.xml
Add the following line in your Manifest file
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
2.Library Initialization 
This line is used to save the exported file in default location.
SqliteToExcel sqliteToExcel = new SqliteToExcel(this, "helloworld.db");
This line is used to save the exported file in used preferred location.
SqliteToExcel sqliteToExcel = new SqliteToExcel(this, "helloworld.db", directory_path);
3.Export DB to Excel 
This code snippet is used to Export a single table in a database to Excel Sheet
sqliteToExcel.startExportSingleTable("table1", "table1.xls", new ExportListener() {
   
 @Override
 public void onStart() {
  
 }
   
 @Override
 public void onError() {
  
 }
   
 @Override
 public void onComplete() {
  
 }
});
This code snippet is used to Export a every table in a database to Excel Sheet
sqliteToExcel.startExportAllTables("helloworlddb.xls", new ExportListener() {
   
 @Override
 public void onStart() {
  
 }
   
 @Override
 public void onError() {
  
 }
   
 @Override
 public void onComplete() {
  
 }
});
Please Visit the Wiki Link for full Guidance on SQLite2XL(v1.0.0). If you Like this library, Please star it in Github.

Github Wiki Link

Share this

Related Posts

Previous
Next Post »

Please Comment about the Posts and Blog