當前位置:編程學習大全網 - 源碼下載 - 求個java讀取csv文件並輸出的程序

求個java讀取csv文件並輸出的程序

要使用CsvReader,CsvWriter需要下載壹個javacsv.jar導入到項目中 

package?test;import?com.csvreader.CsvReader;import?com.csvreader.CsvWriter;import?java.io.BufferedReader;?import?java.io.BufferedWriter;import?java.io.File;?import?java.io.FileNotFoundException;?import?java.io.FileReader;?import?java.io.FileWriter;import?java.io.IOException;?public?class?readandwrite?{public?static?void?main(String[]?args)?throws?IOException?{?String?[]?str?={"省","市","區","街","路","裏","幢","村","室","園","苑","巷","號"};String?inString?=?"";String?tmpString?=?"";File?inFile?=?new?File("C://in.csv");?//?讀取的CSV文件File?outFile?=?new?File("C://outtest.csv");//輸出的CSV文try?{BufferedReader?reader?=?new?BufferedReader(new?FileReader(inFile));BufferedWriter?writer?=?new?BufferedWriter(new?FileWriter(outFile));CsvReader?creader?=?new?CsvReader(reader,?',');CsvWriter?cwriter?=?new?CsvWriter(writer,',');while(creader.readRecord()){inString?=?creader.getRawRecord();//讀取壹行數據for(int?i?=?0;i?<?str.length;i++){tmpString?=?inString.replace(str[i],?","?+?str[i]?+?",");inString?=?tmpString;}//第壹個參數表示要寫入的字符串數組,每壹個元素占壹個單元格,第二個參數為true時表示寫完數據後自動換行cwriter.writeRecord(inString.split(","),?true);//註意,此時再用cwriter.write(inString)方法寫入數據將會看到只往第壹個單元格寫入了數據,“,”沒起到調到下壹個單元格的作用//如果用cwriter.write(String?str)方法來寫數據,則要用cwriter.endRecord()方法來實現換行//cwriter.endRecord();//換行cwriter.flush();//刷新數據}?creader.close();cwriter.close();}?catch?(FileNotFoundException?ex)?{ex.printStackTrace();}}}

  • 上一篇:關於量子通信概念股龍頭有哪些?
  • 下一篇:全國域名空間註冊商排名
  • copyright 2024編程學習大全網