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"	,"231,215.99"	";
//        String money = ",`1004760934201504280095156624,";
//        money = ","1004760934201504280095156624"	,";
        dataList.add(""1004760934201504280095156624"	,"231,215.99"");
        dataList.add(""1004800934201504270092770541"	,"1.1"");
        dataList.add(""1002190934201504260091077987"	");
        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);
            }
        }
    }
    
    
}

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

"1004760934201504280095156624" ,"231,215.99"

"1004800934201504270092770541" ,"1.1"

"1002190934201504260091077987"

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

原文地址:https://www.cnblogs.com/a393060727/p/4464941.html