MIME type for reading CSV file in an Android app does not work

Question

maybe I can get help here. I'm working on an Android app in Java and try to pick a .csv file to import some data:

    public void onButtonImportClick(View view) {
        Log.d(TAG, "onButtonImportClick");
        Intent intent = new Intent(Intent.ACTION_OPEN_DOCUMENT);
        intent.addCategory(Intent.CATEGORY_OPENABLE);
        intent.setType("text/*");
        intent.putExtra(Intent.EXTRA_MIME_TYPES, new String[] { "text/csv", "text/plain" });
        someActivityResultLauncher.launch(intent);
    }

The picker shows files but all are greyed out, besides the .txt files. Actually I expected to get .csv and .txt files. Obviously something is not correct with MIME type setting.
Any ideas or suggestions?

blackgreen · Accepted Answer · 2024-09-30 22:35:31Z

0

Use opencsv for read CSV file.

Add below gradle into gradle file.

implementation 'com.opencsv:opencsv:4.6'

Implement below function for read csv file

CSVReader reader = new CSVReader(new FileReader("yourfile.csv"));
List myEntries = reader.readAll();

edited Sep 30, 2024 at 22:35

blackgreen♦

46.9k29 gold badges171 silver badges162 bronze badges

answered Feb 14, 2024 at 11:39

Hiren Bharodiya

3001 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

reichi Over a year ago

Thank you, but where do I store the yourfile.csv? Ideally it should be in the Download folder of the device. If I do not use a picker, user will not be able to navigate, right?

Hiren Bharodiya Over a year ago

@reichi Yes, you have to select file from local storage & give that file to FileReader

reichi Over a year ago

Okay, but the file will not be in the local storage. It will be provided from user in the download folder. I think I need the file picker.

Collectives™ on Stack Overflow

MIME type for reading CSV file in an Android app does not work

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related