import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.StringTokenizer;
public class ReadCSV {
public static void main(String[] args) {
try {
File csv = new File("C:writers.csv"); // CSV文件
BufferedReader br = new BufferedReader(new FileReader(csv));
// 读取直到最后一行
String line = "";
while ((line = br.readLine()) != null) {
// 把一行数据分割成多个字段
StringTokenizer st = new StringTokenizer(line, ",");
while (st.hasMoreTokens()) {
// 每一行的多个字段用TAB隔开表示
System.out.print(st.nextToken() + "t");
}
System.out.println();
}
br.close();
} catch (FileNotFoundException e) {
// 捕获File对象生成时的异常
e.printStackTrace();
} catch (IOException e) {
// 捕获BufferedReader对象关闭时的异常
e.printStackTrace();
}
}
}
执行结果如下所示:
CSV写操作
CSV文件读取主要用到java.io.BufferedWriter类。
下面是写CSV文件的类:
package tip;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
public class WriteCSV {
public static void main(String[] args) {
try {
File csv = new File("C:writers.csv"); // CSV文件
// 追记模式
BufferedWriter bw = new BufferedWriter(new FileWriter(csv, true));
// 新增一行数据
bw.newLine();
bw.write("三枪拍案惊奇" + "," + "2009" + "," + "1212");
bw.close();
} catch (FileNotFoundException e) {
// 捕获File对象生成时的异常
e.printStackTrace();
} catch (IOException e) {
// 捕获BufferedWriter对象关闭时的异常
e.printStackTrace();
}
}
}