导出excel的方法一般来说有两种,一种是根据反射。通过反射来得到想要的数据,定义excel的表头,得到数据内容。但在很多业务场景中,excel想要展示的数据不单单是某一个类,而是根据业务需要,可能是好几种数据聚合在一起,还有进行计算等等。有的是有选型,选多少,就要支持导出excel多少的数据。
这个时候可以用另一种,自定义表头,思路就是定义一个表头的数组,通过后台聚合数组中所对应的数据
package com.baizhi.test;
import java.io.*;
import java.util.List;
/**
* @ Author hp
* @ Date 2018/12/8
*/
public class CsvUtil {
/**
* CSV文件生成方法
*
* @param head
* @param dataList
* @param outPutPath
* @param filename
* @return
*/
private static File createCSVFile(String[] head, List<String[]> dataList, String outPutPath, String filename) {
File csvFile = null;
BufferedWriter csvWtriter = null;
try {
csvFile = new File(outPutPath + File.separator + filename + ".csv");
File parent = csvFile.getParentFile();
if (parent != null && !parent.exists()) {
parent.mkdirs();
}
csvFile.createNewFile();
// GB2312使正确读取分隔符","
csvWtriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(
csvFile), "GB2312"), 1024);
// 写入文件头部
writeRow(head, csvWtriter);
// 写入文件内容
for (String[] row : dataList) {
writeRow(row, csvWtriter);
}
csvWtriter.flush();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
csvWtriter.close();
} catch (IOException e) {
e.printStackTrace();
}
}
return csvFile;
}
/**
* 写一行数据方法
*
* @param row
* @param csvWriter
* @throws IOException
*/
private static void writeRow(String[] row, BufferedWriter csvWriter) throws IOException {
// 写入文件头部
for (String data : row) {
StringBuffer sb = new StringBuffer();
String rowStr = sb.append("\"").append(data).append("\",").toString();
csvWriter.write(rowStr);
}
csvWriter.newLine();
}
// public static File createDataFile1(List<Map<String, Object>> data,String outPutPath) {
// String[] header = {"渠道", "日期", "激活数", "注册数", "基本信息认证数", "实名认证数",
// "人脸识别数", "运营商认证数", "支付宝认证数", "银行卡认证数", "提交申请数",
// "审核通过数", "首借且通过数","放款人数", "放款额", "入催率"};
// List<String[]> dataList = new ArrayList<>();
// String fileName = "exportChannelTmp";
// for (Map<String,Object> map : data){
// String[] tmp = new String[16];
// tmp[0] = String.valueOf(map.get("channel"));
// tmp[1] = String.valueOf(map.get("date"));
// tmp[2] = String.valueOf(map.get("activiteCount"));
// tmp[3] = String.valueOf(map.get("registCount"));
// tmp[4] = String.valueOf(map.get("basicInfoCount"));
// tmp[5] = String.valueOf(map.get("realnameCount"));
// tmp[6] = String.valueOf(map.get("faceVerifyCount"));
// tmp[7] = String.valueOf(map.get("phoneDataCount"));
// tmp[8] = String.valueOf(map.get("sesameAuthCount"));
// tmp[9] = String.valueOf(map.get("bankCardCount"));
// tmp[10] = String.valueOf(map.get("creditCount"));
// tmp[11] = String.valueOf(map.get("creditSuccessCount"));
// tmp[12] = String.valueOf(map.get("firstBorrowCount"));
// tmp[13] = String.valueOf(map.get("borrowCount"));
// tmp[14] = String.valueOf(map.get("borrowMoneyCount"));
// tmp[15] = String.valueOf(map.get("incomingRate"));
// dataList.add(tmp);
// }
// return createCSVFile(header,dataList,outPutPath,fileName);
// }
}