Read and parse CSV file from asset folder
Description
The following code shows how to Read and parse CSV file from asset folder.
Example
Register permission for WRITE_EXTERNAL_STORAGE
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.java2s.myapplication3.app" >
<uses-sdk
android:minSdkVersion="8"
android:targetSdkVersion="18" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<application
android:allowBackup="true"
android:icon="@drawable/ic_launcher"
android:label="java2s.com"
android:theme="@style/AppTheme" >
<activity
android:name="com.java2s.myapplication3.app.MainActivity"
android:label="java2s.com"
>
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>
</manifest>
Java code for main activity
package com.java2s.myapplication3.app;
/*from w w w .j av a 2 s .c om*/
import android.app.Activity;
import android.content.res.AssetManager;
import android.os.Bundle;
import android.util.Log;
import android.widget.TextView;
import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
public class MainActivity extends Activity {
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
TextView tv = new TextView(this);
setContentView(tv);
try {
AssetManager manager = getAssets();
InputStream in = manager.open("data.csv");
ArrayList<Person> cooked = parse(in);
StringBuilder builder = new StringBuilder();
for(Person piece : cooked) {
builder.append(String.format("%s is %s years old, and likes the color %s",
piece.name, piece.age, piece.color));
builder.append('\n');
}
tv.setText(builder.toString());
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/* Simple CSV Parser */
private static final int COL_NAME = 0;
private static final int COL_AGE = 1;
private static final int COL_COLOR = 2;
private ArrayList<Person> parse(InputStream in) throws IOException {
ArrayList<Person> results = new ArrayList<Person>();
BufferedReader reader = new BufferedReader(new InputStreamReader(in));
String nextLine = null;
while ((nextLine = reader.readLine()) != null) {
String[] tokens = nextLine.split(",");
if (tokens.length != 3) {
Log.w("CSVParser", "Skipping Bad CSV Row");
continue;
}
//Add new parsed result
Person current = new Person();
current.name = tokens[COL_NAME];
current.color = tokens[COL_COLOR];
current.age = tokens[COL_AGE];
results.add(current);
}
in.close();
return results;
}
}
class Person {
public String name;
public String age;
public String color;
public Person() { }
}
data.csv
Jack,Red,12
Jane,Black,13
Jode,Brown,14