大家好，我是你們的導師，我每天都會在這里給大家分享一些干貨內容(當然了，周末也要允許老師休息一下哈)。上次老師跟大家分享了下MyBatis 幾種通用的寫法的相關知識，今天跟大家分享SpringBoot實現快速導出Excel的知識。
1?SpringBoot實現快速導出Excel
工作中經常遇到導出Ecxel功能，這里就給出完整示例代碼，可以直接使用。
1.引入依賴
<dependency> <groupId>org.apache.poigroupId> <artifactId>poi-ooxmlartifactId> <version>3.17version>dependency>2. ExcelSheetSettingEnum
定義Excel的一些配置信息
public enum ExcelSheetSettingEnum { REPORT_TEST("report_test", "Excel文件名稱", new String[]{"Sheet名稱1", "Sheet名稱2"}, new String[]{"標題1", "標題2"}, new String[][]{ {"字段名稱A", "字段名稱B", "字段名稱C", "字段名稱D"}, {"字段名稱A", "字段名稱B", "字段名稱C", "字段名稱D"} }), REPORT_TEST2("report_test2", "Excel文件名稱", new String[]{"標題1", "標題2"}), REPORT_TEST3("report_test3", "Excel文件名稱") ; ExcelSheetSettingEnum(String code, String filename) { this.code = code; this.filename = filename; } ExcelSheetSettingEnum(String code, String filename, String[] titles) { this.code = code; this.filename = filename; this.titles = titles; } ExcelSheetSettingEnum(String code, String filename, String[] sheetnames, String[] titles, String[][] headers) { this.code = code; this.filename = filename; this.sheetnames = sheetnames; this.titles = titles; this.headers = headers; } /** 代碼標識(必選) */ private String code; /** 代碼標識(必選) */ private String filename; /** Sheet名稱(可選) */ private String[] sheetnames; /** Sheet標題(可選) */ private String[] titles; /** 表頭名稱(可選) */ private String[][] headers; // Getter & Setter}3. ExcelView
定義Excel視圖，繼承自AbstractXlsxView或者AbstractXlsView, 需要實現一個abstract方法buildExcelDocument用于創建Sheet，構造Excel數據。
繼承關系如下：
/** * Excel視圖 * * 支持多個Sheet, Sheet名稱、標題和表頭不是必須的 * AbstractPdfView和AbstractXlsxView原理大致相同 * * @author mengday zhang */public class ExcelView extends AbstractXlsxView { @Override protected void buildExcelDocument(Map<String, Object> map, Workbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { ExcelSheetSettingEnum setting = (ExcelSheetSettingEnum) map.get("ExcelSheetSetting"); // 設置文件名稱 String filename = setting.getFilename(); filename = new String(filename.getBytes("UTF-8"),"ISO8859-1"); response.setHeader(HttpHeaders.CONTENT_DISPOSITION,"attachment;filename=" + filename + ".xlsx"); ListString>>> sheets = (List for (int i = 0; i < sheets.size(); i++) { // 創建sheet String[] sheetNames = setting.getSheetnames(); String sheetName = "Sheet" + (i + 1); if (sheetNames != null && sheetNames.length > 0) { sheetName = sheetNames[i]; } Sheet sheet = workbook.createSheet(sheetName); // 如果標題不為空的話，將表格的第一行作為標題行，并合并第一行的N個單元格 int index = 0; String[] titles = setting.getTitles(); String[][] headerss = setting.getHeaders(); ListString>> rowsForTable = sheets.get(i); if (titles != null && titles.length > 0) { // 合并標題單元格 下標從0開始 起始行號，終止行號， 起始列號，終止列號 CellRangeAddress region = new CellRangeAddress(0, 0, 0, rowsForTable.get(0).size() - 1); sheet.addMergedRegion(region); Row titleRow = sheet.createRow(index++); Cell titleCell = titleRow.createCell(0); CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setAlignment(HorizontalAlignment.CENTER); Font font = workbook.createFont(); font.setFontName("黑體"); font.setBold(true); font.setFontHeightInPoints((short) 15); cellStyle.setFont(font); titleCell.setCellStyle(cellStyle); titleCell.setCellValue(titles[i]); } // 創建表頭行 if (headerss != null && headerss.length > 0) { Row headerRow = sheet.createRow(index++); String[] headers = headerss[i]; for(int j = 0; j < headers.length; j++) { headerRow.createCell(j).setCellValue(headers[j]); } } // 創建數據行 AtomicInteger rowIndex = new AtomicInteger(index); rowsForTable.forEach(rowList -> { Row row = sheet.createRow(rowIndex.getAndIncrement()); AtomicInteger x = new AtomicInteger(); rowList.forEach(cell -> row.createCell(x.getAndIncrement()).setCellValue(cell) ); }); } }}4.controller
mvc方法中方法的返回值是ModelAndView, 當代碼執行new ModelAndView(excelView, map)時會執行ExcelView#buildExcelDocument的方法
@RestController@RequestMapping("/excel")public class ExcelController { @RequestMapping("/export") public ModelAndView export(){ ListString>> sheet1 = Arrays.asList( Arrays.asList("1", "11", "111", "1111"), Arrays.asList("2", "22", "222", "2222"), Arrays.asList("3", "33", "333", "3333") ); ListString>> sheet2 = Arrays.asList( Arrays.asList("4", "44", "444", "4444"), Arrays.asList("5", "55", "555", "5555"), Arrays.asList("6", "66", "666", "6666") ); ListString>>> sheets = Arrays.asList(sheet1, sheet2); Map<String, Object> map = new HashMap<>(); map.put("ExcelSheetSetting", ExcelSheetSettingEnum.REPORT_TEST2); map.put("data", sheets); ExcelView excelView = new ExcelView(); return new ModelAndView(excelView, map); }}參考來源：toutiao.com/i6818009760873316875/今天就分享這么多，關于SpringBoot實現快速導出Excel，你學會了多少？歡迎在留言區評論，對于有價值的留言，我們都會一一回復的。如果覺得文章對你有一丟丟幫助，請點右下角【在看】，讓更多人看到該文章。
)
)
