解析CSV文件,引入javacsv.jar包
import java.io.File;
import java.io.FileInputStream;
import java.nio.charset.Charset;
import com.csvreader.CsvReader;
public class ImportFile {
public static void main(String args[]) throws Exception{
String filePath ="d:\\data.csv";
File file_temp = new File(filePath);
if(file_temp.exists() && file_temp.isFile()){
FileInputStream in_temp = new FileInputStream(file_temp);
Charset charSet = Charset.forName("utf-8");
CsvReader cr = new CsvReader(in_temp, ',', charSet);
cr.readHeaders();//读取首行(头部)
while (cr.readRecord()) {
String[] line = cr.getValues();
if(line.length ==0){
continue;
}
String s = line[0];//0表示第一列 ,1表示第二列
System.out.println(s);
}
}
}
}
输出结果:
FLD00033
FLD00031
导出CSV
FileOutputStream out = new FileOutputStream(new File ("D:\\aa.csv"));
Charset charSet = Charset.forName("utf-8");
com.csvreader.CsvWriter cw = new com.csvreader.CsvWriter(out,',',charSet);
String header []={"类别","数量"};
cw.writeRecord(header);
String [] cellValue = new String [1];
//可以循环
cellValue[0] = "导出CSV";
cellValue[0] = "6";
cw.writeRecord(cellValue);
cw.close();
out.flush();
out.close();
CSV读取解析,导出
最新推荐文章于 2023-03-10 16:58:18 发布