java 讀寫csv

來源:互聯網
上載者:User

標籤: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

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.