how to use .csv file in android?

Question

I'm doing a sample Quiz application in Android. I used array to store the Questions and Answers, now I wish to store the questions and answers in a .csv file. it is possible to parse .csv file in Android?

CSV files are files containing comma separated values. You can read these like any other textfile. Apart from that your question is really broad and vague and can't be answered reasonably imho. — user658042
– user658042, Commented Dec 5, 2011 at 12:40

mih · Accepted Answer · 2011-12-05 12:39:42Z

3

CSV stands for Comma-Separated Values. Quite good explanation can be found at wiki: CSV. Since you're programming on Android platform consider using one of availible Java libraries such as OpenCSV or JavaCSV.

answered Dec 5, 2011 at 12:39

mih

5253 silver badges13 bronze badges

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

Comments

Sujit · Accepted Answer · 2011-12-05 12:41:03Z

Put you .csv in the assert folder and access it as follow

I was using .csv to get the list of counter in my application..

public  ArrayList<String> COUNTRIES     = new ArrayList<String>();
    try {

                is = res.getAssets().open("country.csv");
                BufferedReader reader = new BufferedReader(new InputStreamReader(is));
                String line;
                while ((line = reader.readLine()) != null) 
                     COUNTRIES.add(line);

                }
                catch (IOException ex) {
                    // handle exception
                }
                finally {
                    try {
                        is.close();
                    }
                    catch (IOException e) {
                        // handle exception
                    }
                }

user370305 · Accepted Answer · 2011-12-05 12:44:21Z

1

I think this is general discussion, (Not specific to android)

The CSV ("Comma Separated Value") file format is often used to exchange data between disparate applications. The file format, as it is used in Microsoft Excel, has become a pseudo standard throughout the industry, even among non-Microsoft platforms.

There are many ways to generate a csv file. A csv file is a comma delimited data file. Many applications such as Excel or MS Access allow one to save data in csv format. But you can also generate csv files yourself as long as the data is comma delimited and each line is ended with a line break.

For more look at Here and For Android use OpenCSV library.

edited Dec 5, 2011 at 12:44

answered Dec 5, 2011 at 12:39

user370305

109k23 gold badges167 silver badges153 bronze badges

Comments

CloudyMarble · Accepted Answer · 2011-12-05 12:40:29Z

0

CSV, comma separated values, files are commonly used to transport large amounts of tabular data between either companies or applications that are not directly connected. The files are easily editable using common spreadsheet applications like Microsoft Excel.

Collectives™ on Stack Overflow

how to use .csv file in android?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related