| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
jopen
9年前发布

java读取csv文件

CSV其实就是COMMA SEPARATED VALUE的缩写。
在开发中用Java操作csv文件有专门的的API叫javacsv.jar 

javacsv.jar下载地址: 
http://sourceforge.net/project/showfiles.php?group_id=33066

import java.io.IOException;     import java.nio.charset.Charset;     import java.util.ArrayList;     import java.util.List;          import com.csvreader.CsvReader;     import com.csvreader.CsvWriter;     import com.syc.test.DAO.ConnectionDB;     import com.syc.test.bean.ReslutBean;          public class Java2CSV {         /**         * @param args         * @throws Exception         */        public static void main(String[] args) throws Exception {             // 从获取将要写入csv文件的结果集             List<ReslutBean> list = new ArrayList<ReslutBean>();             list = ConnectionDB.querySQL();                  // 预组装csv文件内容标题行             String[][] data = new String[list.size() + 1][2];             data[0][0] = "Help_keyword_id";             data[0][1] = "Name";                  // 预组装csv文件内容             int len = list.size();             for (int i = 0; i < len; i++) {                 data[i + 1][0] = list.get(i).getHelp_keyword_id();                 data[i + 1][1] = list.get(i).getName();             }                  writerCsv("e://c测试.csv", data);             readerCsv("e://c测试.csv");         }              /**         * 读取csv         *          * @param csvFilePath         * @throws Exception         */        public static void readerCsv(String csvFilePath) throws Exception {                  CsvReader reader = new CsvReader(csvFilePath, ',',                     Charset.forName("GBK"));// shift_jis日语字体,utf-8            reader.readHeaders();             String[] headers = reader.getHeaders();                  List<Object[]> list = new ArrayList<Object[]>();             while (reader.readRecord()) {                 list.add(reader.getValues());             }             Object[][] datas = new String[list.size()][];             for (int i = 0; i < list.size(); i++) {                 datas[i] = list.get(i);             }                  /*             * 以下输出             */                 for (int i = 0; i < headers.length; i++) {                 System.out.print(headers[i] + "\t");             }             System.out.println("");                  for (int i = 0; i < datas.length; i++) {                 Object[] data = datas[i]; // 取出一组数据                for (int j = 0; j < data.length; j++) {                     Object cell = data[j];                     System.out.print(cell + "\t");                 }                 System.out.println("");             }         }         }