SQlite database programmatically convert into Excel file format in Android

android sqlite file-conversion
Mohit Raval picture Mohit Raval · Oct 25, 2012 · Viewed 15.8k times · Source

I am developing android app where SQlite as a database.I want to export my android app database in to excel file format programmatically, so that normal people can read their database easily.If it is possible than please give me hint or not than help me to convert any other file format like text file or other. thanks for voting...

Answer

JustDanyul picture JustDanyul · Oct 25, 2012

Excel reads CSV, so this would by far be your easiest option. Have a look at opencsv

http://opencsv.sourceforge.net

it contains pretty much everything you need. The process becomes as simple as:

  1. read the data you wish to export from Sqlite.
  2. write the results into a csv file (remember to name it *something***.csv**, so excel will know its a csv file)

and thats it really :)

EDIT: Based on your comments below, I suggest you take a look at this thread

How can I use external JARs in an Android project?

EDIT for gradle dependencies

Add compile 'com.opencsv:opencsv:4.1' to app gradle. That's it. No need to add jars.

Reference: http://opencsv.sourceforge.net/dependency-info.html

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to delete all records from table in sqlite with Android?

My app has two buttons, the first button is for deleting record on user input and the second button is for deleting all records. But when I want to delete data it shows the message "Your application has been forcefully …

Read More
How to store image in SQLite database

In my application I am uploading an image from gallery and I want to store this image in the SQLite database. How do I store a bitmap in the database? I am converting bitmap to a string and saving it …

Read More