本文主要是介绍Java(若依)：Map导出，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
Controller
/*** 导出* @param response* @param lssjcx*/
@PostMapping("/export")
public void export(HttpServletResponse response, User user){List<Map<String, Object>> resMap = userMapper.list(user);ExcelUtilT utilT = new ExcelUtilT();utilT.createExcel(response, resMap,"", "");
}
Utils工具类
public class ExcelUtilT {private static ExcelUtilT instance = new ExcelUtilT();public ExcelUtilT() {}public static ExcelUtilT getInstance() {return instance;}/*** 将 List<Map<String,Object>> 类型的数据导出为 Excel* 默认 Excel 文件的输出路径为 项目根目录下* 文件名为 filename + 时间戳 + .xlsx** @param mapList 数据源(通常为数据库查询数据)* @param filename 文件名前缀, 实际文件名后会加上日期* @param title 表格首行标题*/public void createExcel(HttpServletResponse response, List<Map<String, Object>> mapList, String filename, String title) {// 获取数据源的 key, 用于获取列数及设置标题Map<String, Object> map = mapList.get(0);Set<String> stringSet = map.keySet();List<String> headList = new ArrayList<>(stringSet);Collections.sort(headList); // 表头排序// 定义一个新的工作簿XSSFWorkbook wb = new XSSFWorkbook();// 创建一个Sheet页XSSFSheet sheet = wb.createSheet();// 设置标题样式XSSFCellStyle headWriteCellStyle = getTitleStyle(wb);// 设置标题setTitle(sheet, headList, headWriteCellStyle);// 设置内容样式XSSFCellStyle contentWriteCellStyle = getContentStyle(wb);// 设置内容setContent(sheet, headList, mapList, contentWriteCellStyle);// 导出export(response, wb, filename);}public void setTitle(XSSFSheet sheet, List<String> headList, XSSFCellStyle headWriteCellStyle) {// 设置标题XSSFRow row = sheet.createRow(0);sheet.autoSizeColumn(0);for (int i = 0; i < headList.size(); i++) {XSSFCell cell = row.createCell(i);cell.setCellValue(headList.get(i));cell.setCellStyle(headWriteCellStyle);}}public XSSFCellStyle getTitleStyle(XSSFWorkbook wb) {// 单元格样式类XSSFCellStyle headWriteCellStyle = wb.createCellStyle();// 设置单元格背景颜色headWriteCellStyle.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 128, 128)));headWriteCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);// 文字水平垂直居中headWriteCellStyle.setAlignment(HorizontalAlignment.CENTER); // 水平居中headWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // 垂直居中// 设置字体XSSFFont headWriteFont = wb.createFont();headWriteFont.setFontName("Arial"); // 字体样式headWriteFont.setFontHeightInPoints((short) 10); // 字体大小headWriteFont.setBold(true); // 加粗headWriteFont.setColor(IndexedColors.WHITE.getIndex());headWriteCellStyle.setFont(headWriteFont);return headWriteCellStyle;}public void setContent(XSSFSheet sheet, List<String> headList, List<Map<String, Object>> mapList, XSSFCellStyle contentWriteCellStyle) {XSSFRow rows;XSSFCell cells;// 循环拿到的数据给所有行每一列设置对应的值for (int i = 0; i < mapList.size(); i++) {//在这个sheet页里创建一行rows = sheet.createRow(i + 1);sheet.autoSizeColumn(i + 1);//给该行数据赋值for (int j = 0; j < headList.size(); j++) {String value = mapList.get(i).get(headList.get(j)).toString();cells = rows.createCell(j);cells.setCellValue(value);cells.setCellStyle(contentWriteCellStyle);}}}public XSSFCellStyle getContentStyle(XSSFWorkbook wb) {// 单元格样式类XSSFCellStyle contentWriteCellStyle = wb.createCellStyle();// 设置单元格背景颜色contentWriteCellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());contentWriteCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);// 文字水平垂直居中contentWriteCellStyle.setAlignment(HorizontalAlignment.CENTER); // 水平居中contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // 垂直居中// 设置边框contentWriteCellStyle.setBorderTop(BorderStyle.THIN);contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);contentWriteCellStyle.setBorderLeft(BorderStyle.THIN);contentWriteCellStyle.setBorderRight(BorderStyle.THIN);// 设置字体XSSFFont headWriteFont = wb.createFont();headWriteFont.setFontName("Arial"); // 字体样式headWriteFont.setFontHeightInPoints((short) 10); // 字体大小contentWriteCellStyle.setFont(headWriteFont);return contentWriteCellStyle;}public void export(HttpServletResponse response, XSSFWorkbook wb, String filename) {response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");response.setCharacterEncoding("utf-8");try {wb.write(response.getOutputStream());} catch (Exception e) {System.out.printf("导出Excel异常{}", e.getMessage());} finally {IOUtils.closeQuietly(wb);}}
}
前端调用
handleExport(){this.download('/xxx/export', {...this.queryParams}, `user_${new Date().getTime()}.xlsx`)
},
这篇关于Java(若依)：Map导出的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
