Preparation: Need to reference Javacsv.jar
Read CSV
public void Readcsv () throws Span lang= "en-US" style= "font-family:consolas; Color:black; Font-size:10pt "> IOException {
arraylist<string[]> csvlist =newarraylist<string[]> ();
String csvfilepath =sourcepath;
Csvreader reader =newcsvreader (csvfilepath,', ', Charset. Forname("SJIS"));
reader.readheaders ();
while(Reader.readrecord ()) {
Csvlist.add (Reader.getvalues ());
}
reader.close ();
for (int row = 0;row < Csvlist.size (); row++) {
string[] coldata=csvlist.get (ROW);
if(coldata!=null)
{
for(intcol=0;col<coldata. length ; col++)
{
System. out .println ( +row+ "; Col= " +col+ ";D ata= " + Coldata[col]);
}
}
}
}
Write CSV
public void Writecvs (arraylist<string[]> dataList) ThrowsIOException {
String csvfilepath = summetricspath
Csvwriter wr =newcsvwriter (csvfilepath,', ', Charset. Forname("SJIS"));
string[] Header = { "Name","COL1","COL2","COL3","COL4","COL5" };
Wr.writerecord (header);
for(intindex=0;index<datalist.size (); index++)
{
string[] data= datalist.get (index);
Wr.writerecord (data);
}
wr.close ();
}
Read/write CSV file