標籤:headers tac aaaaa end row com str nbsp main
import java.io.IOException;import java.nio.charset.Charset;import com.csvreader.CsvReader;import com.csvreader.CsvWriter;public class CsvUtil { /** * 讀取CSV檔案 * @throws Exception */ public static void readeCsv() throws Exception{ CsvReader r = new CsvReader("d:/test2.csv", ‘,‘,Charset.forName("GBK")); //讀取表頭 while(r.readHeaders()){ System.out.println(r.getRawRecord()); } //逐條讀取記錄,直至讀完 while (r.readRecord()) { //讀取一條記錄 System.out.println(r.getRawRecord()); //按列名讀取這條記錄的值 System.out.println(r.get("Name")); System.out.println(r.get("class")); System.out.println(r.get("number")); System.out.println(r.get("sex")); } r.close();} /** * 寫入CSV檔案 */ public static void writeCsv(){ try { String csvFilePath = "d:/test2.csv"; CsvWriter wr =new CsvWriter(csvFilePath, ‘,‘,Charset.forName("GBK"));// String[] contents = {"aaaaa","bbbbb","cccccc","ddddddddd"}; String[] contents = {"Lilymm","五一","90","女"}; String[] contents2 = {"Lilyo","五一","90","女"}; wr.writeRecord(contents); wr.writeRecord(contents2); wr.close(); } catch (IOException e) { e.printStackTrace(); } } public static void main(String[] args) { writeCsv(); try { readeCsv(); } catch (Exception e) { e.printStackTrace(); } }}
<dependency> <groupId>net.sourceforge.javacsv</groupId> <artifactId>javacsv</artifactId> <version>2.0</version> </dependency>
java 讀寫csv