csv测试类。用起来,就是那么简单。每个单元格都是以逗号分隔

package com.hyxt.wxpay.util;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

import org.junit.Test;

/**
 * CSV操作(导出和导入)
 * 
 * @author 林计钦
 * @version 1.0 Jan 27, 2014 4:17:02 PM
 */
public class CsvTest {

    /**
     * CSV导出
     * 
     * @throws Exception
     */
    @Test
    public void exportCsv() {
        List<String> dataList=new ArrayList<String>();
        String money = "";
        money = "\"AA,BB,CC\",\"231,231,231,215.99\"";
//      money = "`AA,`BB,`CC,`231,215.99";
//      money = money.replaceAll(",", ",\"");
//      dataList.add(money);
//      money = "`12,`33,\"44\"\t,\"231,215.99\"\t";
//        String money = ",`1004760934201504280095156624,";
//        money = ",\"1004760934201504280095156624\"\t,";
        dataList.add("\"1004760934201504280095156624\"\t,\"231,215.99\"");
        dataList.add("\"1004800934201504270092770541\"\t,\"1.1\"");
        dataList.add("\"1002190934201504260091077987\"\t");
        dataList.add(money);
        
        System.out.println(dataList);
        boolean isSuccess=CSVUtils.exportCsv(new File("E:/export/ljq"+Math.random()+".csv"), dataList);
//        boolean isSuccess=CSVUtils.exportCsv(new File("E:/export/ljq"+DateUtil.getCurrentDateStr(DateUtil.DATETIMEFMTSSSS)+".csv"), dataList);
        System.out.println(isSuccess);
    }
    
    /**
     * CSV导导入
     * 
     * @throws Exception
     */
//    @Test
    public void importCsv()  {
        List<String> dataList=CSVUtils.importCsv(new File("E:/test/ljq.csv"));
        if(dataList!=null && !dataList.isEmpty()){
            for(String data : dataList){
                System.out.println(data);
            }
        }
    }
    
    
}

结果:以逗号分隔,以\n换行,字符串加上\t,数字加上双引号""

"1004760934201504280095156624" ,"231,215.99"

"1004800934201504270092770541" ,"1.1"

"1002190934201504260091077987"

"AA,BB,CC","231,231,231,215.99"

posted on 2015-04-29 09:14  陈惟鲜的博客  阅读(336)  评论(0编辑  收藏  举报

导航