/**
* 实现了读取一个本地文件,然后写出到另一个文件
*
* @param file csv文件(路径+文件)
* @return
*/
public static void importCsv(File file){
BufferedReader br=null;
BufferedWriter bw = null;
try {
//输出流
FileOutputStream fos = new FileOutputStream(new File("C:/jtyh/export/newexport/CUST_tx_tmp.csv"));//guar trade tx
// 写入bom头。微软的excel用这个,不会中文乱码
byte[] uft8bom={(byte)0xef,(byte)0xbb,(byte)0xbf};
fos.write(uft8bom);
bw =new BufferedWriter(new OutputStreamWriter(fos, "UTF-8"));
//生成csv的标题头
bw.append("NODE_ID,CUST_NAME,FIRST_BRACH,CREDIT_BALANCE").append("\r");
br = new BufferedReader(new FileReader(file));
String line = "";
while ((line = br.readLine()) != null) {
bw.append(line).append("\r");
}
}
}catch (Exception e) {
}finally{
if(br!=null){
try {
br.close();
bw.close();
bw=null;
br=null;
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
java 导入导出CSV
最新推荐文章于 2024-05-29 08:28:42 发布