Android open XLSX file

Question

I'm trying to open an XLSX file within my Android App.

I'm aware that the Intent type I have to fire is application/excel, but despite I've installed Google Sheets, my code says that no application can open my excel file.

This is the code I use to fire the Intent:

private void openXLS(){
        File xls = new File(Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOCUMENTS), "prova.xlsx");
        Uri path = Uri.fromFile(xls);
        Intent intent = new Intent(Intent.ACTION_VIEW);
        intent.setDataAndType(path, "application/excel");
            intent.setFlags(Intent.FLAG_ACTIVITY_NEW_TASK);

        try {
            context.startActivity(intent);
        } catch (ActivityNotFoundException e) {
            Toast.makeText(context, "No Application available to view XLS", Toast.LENGTH_SHORT).show();
        }
    }

Note: prova.xlsx exists, and I'm able to reach it and open it.

You might want to write your own reader. A tutorial here: http://www.mysamplecode.com/2011/10/android-read-write-excel-file-using.html — Phantômaxx, May 08 '15 at 08:18
check out.http://stackoverflow.com/questions/21877532/how-to-create-docx-files-and-xlsx-files-on-android/22083003#22083003 — devcelebi, May 08 '15 at 08:19

Luca · Accepted Answer · 2015-05-09T07:32:49.587

11

SOLVED

Using the MIME type application/vnd.ms-excel, *.xls and *.xlsx files can be opened.

edited May 09 '15 at 07:32

answered May 09 '15 at 06:21

Luca

823
4
11
31

No only xls files are opened – moumenShobakey Feb 06 '21 at 06:57

score 1 · Answer 2 · answered Apr 03 '19 at 09:54

private void openXLS(final String path) {
    File file = new File(path);
    Uri uri ;
    if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.M) {
                uri = FileProvider.getUriForFile(context, context.getPackageName() + ".provider", file);
            } else {
                uri = Uri.fromFile(file);
            }

    Intent intent = new Intent(Intent.ACTION_VIEW);
    intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
    intent.setDataAndType(path, "application/vnd.ms-excel");
    intent.setFlags(Intent.FLAG_GRANT_READ_URI_PERMISSION); 
    try {
        startActivity(intent);
    } catch (ActivityNotFoundException e) {
        Toast.makeText(this, "Application not found", Toast.LENGTH_SHORT).show();
    }
}

Android open XLSX file

2 Answers2