Is There Any Way To Open An Xls Sheet In Android?

I am newbie in Android, so I have limited knowledge. Can anyone let me to know if there is any way to open an xls sheet in Android?

Solution 1:

Without writing your own reader specific to that file format (the spec for which can be found here. Be warned, it's like an 1,100 page PDF if you download it), you'll need a library to include in your project, or you could probably attempt to launch it via Intent. I believe most phones have some sort of QuickOffice or similar app installed, but it's certainly no guarantee.

Here is a Java library for reading/writing Excel files that I found in response to this question.

Solution 2:

There are two popular libraries to read and write Excel files with Java (and so, with Android): Apache POI and JExcelAPI.

Apache POI is actively maintained (as of 2014), JExcelAPI looks like its not under active development. ApachePOI can read .xlsx files which JExcelAPI cannot, which may be important for a lot of users.

What I like the most about Apache POI is its event-based Parsing model, which has a very low memory profile when reading large Excel sheets. This i especially useful on mobile devices like Android. In my experience, loading a simple Excel file with 2 sheets, a few hundred row and some formulas with JExcelAPI exceeded the memory limit (OutOfMemoryException) of the Dalvik VM on mid to low-end devices (1GB total RAM or less).