1.CsvReader读取
import com.csvreader.CsvReader;
public static ArrayList readCsvByCsvReader(String filePath) {
ArrayList strList = null;
try {
ArrayList arrList = new ArrayList();
strList = new ArrayList();
CsvReader reader = new CsvReader(filePath, ',', Charset.forName("UTF-8"));
while (reader.readRecord()) {
// System.out.println(Arrays.asList(reader.getValues()));
arrList.add(reader.getValues()); // 按行读取,并把每一行的数据添加到list集合
}
reader.close();
System.out.println("读取的行数:" + arrList.size());
// 如果要返回 String[] 类型的 list 集合,则直接返回 arrList
// 以下步骤是把 String[] 类型的 list 集合转化为 String 类型的 list 集合
for (int row = 0; row < arrList.size(); row++) {
// 组装String字符串
// 如果不知道有多少列,则可再加一个循环
String ele = arrList.get(row)[0] + "," + arrList.get(row)[1] + ","
+ arrList.get(row)[2] + "," + arrList.get(row)[3] ;
System.out.println(ele);
strList.add(ele);
}
} catch (Exception e) {
e.printStackTrace();
}
return strList;
}
CsvReader方式需要引入jar包,pom配置如下
net.sourceforge.javacsv
javacsv
2.0
2.BufferedReader读取
public static ArrayList readCsvByBufferedReader(String filePath) {
File csv = new File(filePath);
csv.setReadable(true);
csv.setWritable(true);
InputStreamReader isr = null;
BufferedReader br = null;
try {
isr = new InputStreamReader(new FileInputStream(csv), "UTF-8");
br = new BufferedReader(isr);
} catch (Exception e) {
e.printStackTrace();
}
String line = "";
ArrayList records = new ArrayList<>();
try {
while ((line = br.readLine()) != null) {
System.out.println(line);
records.add(line);
}
System.out.println("csv表格读取行数:" + records.size());
} catch (IOException e) {
e.printStackTrace();
}
return records;
}



