Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Viewing excel files in my android app

Tags:

android

excel

I'm working on an Android app in which I have to open & close excel files on button click. These excel files will be readonly. After closing the excel file, it should direct me to the app.

Please suggest me a way to do this.

like image 819
Venkata Krishna Avatar asked Aug 24 '11 03:08

Venkata Krishna


1 Answers

Android 7.0 Update:

Android 7.0 will throw FileUriExposedException if you try to open your app document with an external app. You need to implement FileProvider refer This Answer.


here is a manual route.

Using JExcelApi in an Android App

How to read excel file using JXL 2.6.12 jar


but here is a little more easier one.

open application

but i guess you have to find out the MIME TYPE.

EDIT

got the mime type as well

Setting mime type for excel document

UPDATE

so something like this might work.

Intent intent = new Intent(Intent.ACTION_VIEW);
intent.setDataAndType(path, "application/vnd.ms-excel");
intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);


try {
    startActivity(intent);
} 
catch (ActivityNotFoundException e) {
    Toast.makeText(OpenDoc.this, "No Application Available to View Excel", Toast.LENGTH_SHORT).show();
}
like image 188
Samuel Avatar answered Oct 21 '22 20:10

Samuel