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"