导出excel的方法一般来说有两种，一种是根据反射。通过反射来得到想要的数据，定义excel的表头，得到数据内容。但在很多业务场景中，excel想要展示的数据不单单是某一个类，而是根据业务需要，可能是好几种数据聚合在一起，还有进行计算等等。有的是有选型，选多少，就要支持导出excel多少的数据。
这个时候可以用另一种，自定义表头，思路就是定义一个表头的数组，通过后台聚合数组中所对应的数据
package com.baizhi.test;import java.io.*;import java.util.List;/*** @ Author hp* @ Date /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);// }}
