easypoi一个excel导出多sheet
public void downloadTheImporTemplate(HttpServletRequest request, HttpServletResponse response) {
String classpath = ClassUtils.getDefaultClassLoader().getResource("").getPath();
String downLoadPath = classpath + "/static/common/importTemplate/downloadTheImporTemplate.xls";
TemplateExportParams params = new TemplateExportParams(downLoadPath);
Integer[] sheetNum = new Integer[] { 0,1,2 };
params.setSheetNum(sheetNum);
/* params.set */
Map<String, Object> map = new HashMap<String, Object>();
/* List<Map<String, Object>> listMap = new ArrayList<Map<String,Object>>(); */
Workbook workbook = ExcelExportUtil.exportExcel(params, map);
/* Workbook workbook = ExcelExportUtil.exportExcel(listMap,ExcelType.HSSF); */
response.setContentType("application/msexcel;charset=UTF-8");
EasyPoiUtil.downLoadExcel("设备信息导入模板.xls", response, workbook);
}
关键代码:
Integer[] sheetNum = new Integer[] { 0,1,2 };
params.setSheetNum(sheetNum);
则导出的是前三页,以此类推