当前位置： 首页 > news >正文

使用 easypoi 导出带三级下拉联动的 excel

news 2024/5/20 8:10:05

关键方法：

    public static void insertThreeCascadeSelectData( Workbook workbook,TreeMap<String, TreeMap<String,List<String>>> selectTree,Integer colIndex_firstSelect,Integer colIndex_secondSelect,Integer colIndex_thirdSelect ) {if( selectTree == null ||selectTree.size() == 0 ||colIndex_firstSelect == null ||colIndex_secondSelect == null ||colIndex_thirdSelect == null ){return;}Sheet sheet = workbook.getSheetAt(0);if( sheet == null ){return;}String hiddenSheetName = "hiddensheet";Sheet hiddenSheet = workbook.createSheet( hiddenSheetName );// 将 selectTree 数据写到 隐藏 sheet 中Set<String> firstSelectNames = selectTree.keySet();// 都写到第一列，每列最多可以写65535行，写满了再写到第二列，以此类推...// 插入一级下拉框名称数据int rowIndex = 0;int colIndex = 0;Row row = getOrCreateRow(hiddenSheet, rowIndex++);int beginRowIndex = rowIndex + 1;int endRowIndex = 0;String formulaName = "total" + firstSelectNames.size() + "firstSelect";String formulaName_firstSelect = formulaName;row.createCell( colIndex ).setCellValue( formulaName );for( String firstSelectName:firstSelectNames ){row = getOrCreateRow(hiddenSheet, rowIndex++);row.createCell( colIndex ).setCellValue( firstSelectName );}endRowIndex = rowIndex;String colName = getColNameByColIndex(colIndex);String formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );// 插入二级下拉框名称数据for( String firstSelectName:firstSelectNames ){TreeMap<String, List<String>> map_secondSelectName_thirdSelectNames = selectTree.get( firstSelectName );Set<String> secondSelectNames = map_secondSelectName_thirdSelectNames.keySet();row = getOrCreateRow(hiddenSheet, rowIndex++);formulaName = firstSelectName;row.createCell( colIndex ).setCellValue( formulaName );beginRowIndex = rowIndex + 1;for( String secondSelectName:secondSelectNames ){row = getOrCreateRow( hiddenSheet,rowIndex++ );row.createCell( colIndex ).setCellValue( secondSelectName );}endRowIndex = rowIndex;colName = getColNameByColIndex( colIndex );formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );}// 插入三级下拉框名称数据for( String firstSelectName:firstSelectNames ){TreeMap<String, List<String>> map_secondSelectName_thirdSelectNames = selectTree.get( firstSelectName );Set<String> secondSelectNames = map_secondSelectName_thirdSelectNames.keySet();for( String secondSelectName:secondSelectNames ){List<String> thirdSelectNames = map_secondSelectName_thirdSelectNames.get( secondSelectName );if( rowIndex >= XLSX_MAX_ROW_NUM ){rowIndex = 0;colIndex++;}row = getOrCreateRow( hiddenSheet, rowIndex++ );formulaName =  secondSelectName;row.createCell( colIndex ).setCellValue( formulaName );beginRowIndex = rowIndex + 1;for( String thirdSelectName:thirdSelectNames ){row = getOrCreateRow( hiddenSheet, rowIndex++ );row.createCell( colIndex ).setCellValue( thirdSelectName );}endRowIndex = rowIndex;colName = getColNameByColIndex( colIndex );formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );}}XSSFDataValidationHelper helper = new XSSFDataValidationHelper( ( XSSFSheet ) sheet );// 设置第1个下拉框XSSFDataValidationConstraint constraint_firstSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST, formulaName_firstSelect );CellRangeAddressList region_firstSelect = new CellRangeAddressList( 2, XLSX_MAX_ROW_NUM, colIndex_firstSelect, colIndex_firstSelect );XSSFDataValidation validation_firstSelect = (XSSFDataValidation) helper.createValidation( constraint_firstSelect, region_firstSelect );validation_firstSelect.setShowErrorBox( true );sheet.addValidationData( validation_firstSelect );// 设置第2个下拉框colName = getColNameByColIndex( colIndex_firstSelect );String indirect = "INDIRECT($" + colName + "2)";System.out.println( indirect );XSSFDataValidationConstraint constraint_secondSelect = (XSSFDataValidationConstraint) helper.createFormulaListConstraint( indirect );// XSSFDataValidationConstraint constraint_secondSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST,indirect  );CellRangeAddressList region_secondSelect = new CellRangeAddressList( 1, XLSX_MAX_ROW_NUM, colIndex_secondSelect, colIndex_secondSelect );XSSFDataValidation validation_secondSelect = (XSSFDataValidation) helper.createValidation( constraint_secondSelect, region_secondSelect );validation_secondSelect.setShowErrorBox( true );sheet.addValidationData( validation_secondSelect );// 设置第3个下拉框colName = getColNameByColIndex( colIndex_secondSelect );indirect = "INDIRECT($" + colName + "2)";System.out.println( indirect );XSSFDataValidationConstraint constraint_thirdSelect = (XSSFDataValidationConstraint) helper.createFormulaListConstraint( indirect );// XSSFDataValidationConstraint constraint_thirdSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST,indirect  );CellRangeAddressList region_thirdSelect = new CellRangeAddressList( 1, XLSX_MAX_ROW_NUM, colIndex_thirdSelect, colIndex_thirdSelect );XSSFDataValidation validation_thirdSelect = (XSSFDataValidation) helper.createValidation( constraint_thirdSelect, region_thirdSelect );validation_thirdSelect.setShowErrorBox( true );sheet.addValidationData( validation_thirdSelect );// 隐藏临时数据sheetint sheetCount = workbook.getNumberOfSheets();for (int i = 0; i < sheetCount; i++) {Sheet currSheet = workbook.getSheetAt(i);if( currSheet.getSheetName().equals( hiddenSheetName ) ){workbook.setSheetHidden(i, true);}}}

完成的 Excel工具类：

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
import com.alibaba.fastjson.JSONObject;
import com.goldwind.ipark.common.util.TimeNodeUtil;
import com.pumch.ipark.pojo.model.ExcelCellRange;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.xssf.usermodel.XSSFDataValidation;
import org.apache.poi.xssf.usermodel.XSSFDataValidationConstraint;
import org.apache.poi.xssf.usermodel.XSSFDataValidationHelper;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDataValidation;
import org.springframework.web.multipart.MultipartFile;import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.text.ParseException;
import java.util.*;//Excel导入导出工具类
public class ExcelUtils {private static final Integer XLSX_MAX_ROW_NUM = 60000;/*** 功能描述：复杂导出Excel，包括文件名以及表名。创建表头* @param list 导出的实体类* @param title 表头名称* @param sheetName sheet表名* @param pojoClass 映射的实体类* @param isCreateHeader 是否创建表头* @param fileName* @param response* @return*/public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, boolean isCreateHeader, HttpServletResponse response) {ExportParams exportParams = new ExportParams(title, sheetName, ExcelType.HSSF);exportParams.setCreateHeadRows(isCreateHeader);defaultExport(list, pojoClass, fileName, null,response, exportParams);}/*** 功能描述：复杂导出Excel，包括文件名以及表名,不创建表头* @param list 导出的实体类* @param title 表头名称* @param sheetName sheet表名* @param pojoClass 映射的实体类* @param fileName* @param response* @return*/public static void exportExcel(List<?> list,String title,String sheetName,Class<?> pojoClass,String fileName,Map<ExcelCellRange,List<String>> selectMap,HttpServletResponse response) {defaultExport(list, pojoClass, fileName, selectMap,response, new ExportParams(title, sheetName, ExcelType.XSSF));}/*** @param modles* @param title* @param sheetName* @param modleClass* @param saveFilePath* @param colIndex_firstSelect 第一列是0* @param colIndex_secondSelect 第一列是0* @param colIndex_thirdSelect 第一列是0* @param selectTree*/public static void exportExcelWithThreeCascadeSelect( List<?> modles,String title,String sheetName,Class<?> modleClass,String fileName,Integer colIndex_firstSelect,Integer colIndex_secondSelect,Integer colIndex_thirdSelect,TreeMap<String,TreeMap<String,List<String>>> selectTree,HttpServletResponse response ) {ExportParams exportParams = new ExportParams(title, sheetName, ExcelType.XSSF);Workbook workbook = ExcelExportUtil.exportExcel(exportParams, modleClass, modles);// 添加三级联动下拉框ExcelUtils.insertThreeCascadeSelectData( workbook,selectTree,colIndex_firstSelect,colIndex_secondSelect,colIndex_thirdSelect );// 下载内存中的 workbook 到输出流downLoadExcel( fileName,response,workbook );}public static void exportExcelWithSelect(List<?> list,String title,String sheetName,Class<?> pojoClass,String fileName,Map<Integer,List<String>> selectMap,HttpServletResponse response) {defaultExport(list, pojoClass, fileName, null,response, new ExportParams(title, sheetName, ExcelType.XSSF));}/*** 功能描述：Map 集合导出** @param list 实体集合* @param fileName 导出的文件名称* @param response* @return*/public static void exportExcel(List<Map<String, Object>> list, String fileName, HttpServletResponse response) {defaultExport(list, fileName, response);}/*** 功能描述：默认导出方法* @param list 导出的实体集合* @param fileName 导出的文件名* @param pojoClass pojo实体* @param exportParams ExportParams封装实体* @param response* @return*/private static void defaultExport(List<?> list,Class<?> pojoClass,String fileName,Map<ExcelCellRange,List<String>> selectMap,HttpServletResponse response,ExportParams exportParams) {long t1 = System.currentTimeMillis();System.out.println( "开始导出excel..." );Workbook workbook = ExcelExportUtil.exportExcel(exportParams, pojoClass, list);long t2 = System.currentTimeMillis();System.out.println( "导出excel完毕...导出耗时：" + ( t2 - t1 ) + "毫秒" );
//        //添加自定义样式
//        exportParams.setStyle(ExcelExportStylerUtil.class);// 添加下拉框// ExcelUtils.insertSelectList( workbook,selectMap );ExcelUtils.insertSelectListForLargeSelect( workbook,selectMap );if (workbook != null) {long t3 = System.currentTimeMillis();System.out.println( "开始下载excel..." );downLoadExcel(fileName, response, workbook);long t4 = System.currentTimeMillis();System.out.println( "下载excel完毕...下载耗时：" + ( t4 - t3 ) + "毫秒" );}}public static void insertSelectListForLargeSelect( Workbook workbook,Map<ExcelCellRange, List<String>> selectMap) {if( selectMap == null || selectMap.size() == 0 ){return;}Sheet sheet = workbook.getSheetAt(0);if( sheet == null ){return;}Set<ExcelCellRange> excelCellRanges = selectMap.keySet();for( ExcelCellRange excelCellRange:excelCellRanges ){Integer beginRow = excelCellRange.getBeginRow();Integer endRow = excelCellRange.getEndRow();Integer beginCol = excelCellRange.getBeginCol();Integer endCol = excelCellRange.getEndCol();String hiddenSheetName = "hiddensheet" + System.currentTimeMillis();Sheet hiddenSheet = workbook.createSheet( hiddenSheetName );List<String> selectList = selectMap.get(excelCellRange);int selctSize = selectList.size();for (int i = 0; i < selctSize; i++) {String selectValue = selectList.get(i);hiddenSheet.createRow( i ).createCell( 0 ).setCellValue( selectValue );}// 添加名称管理器// Name name = workbook.createName();// name.setNameName(hiddenSheetName);// String formulaText = "formulaText_beginRow" + beginRow + "_endRow" + endRow + "_beginCol" + beginCol + "_endCol" + endCol;String formula = hiddenSheetName + "!$A$1:$A$" + selctSize;// name.setRefersToFormula( formulaText );//设置下拉不受限制XSSFDataValidationConstraint constraint = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST, formula );// 设置区域边界CellRangeAddressList region = new CellRangeAddressList(beginRow, endRow, beginCol, endCol);XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSheet) sheet);XSSFDataValidation validation = (XSSFDataValidation) helper.createValidation(constraint, region);// 输入非法数据时，弹窗警告框validation.setShowErrorBox(true);sheet.addValidationData(validation);int sheetCount = workbook.getNumberOfSheets();for (int i = 0; i < sheetCount; i++) {Sheet currSheet = workbook.getSheetAt(i);if( currSheet.getSheetName().equals( hiddenSheetName ) ){workbook.setSheetHidden(i, true);}}}}public static void insertThreeCascadeSelectData( Workbook workbook,TreeMap<String, TreeMap<String,List<String>>> selectTree,Integer colIndex_firstSelect,Integer colIndex_secondSelect,Integer colIndex_thirdSelect ) {if( selectTree == null ||selectTree.size() == 0 ||colIndex_firstSelect == null ||colIndex_secondSelect == null ||colIndex_thirdSelect == null ){return;}Sheet sheet = workbook.getSheetAt(0);if( sheet == null ){return;}String hiddenSheetName = "hiddensheet";Sheet hiddenSheet = workbook.createSheet( hiddenSheetName );// 将 selectTree 数据写到 隐藏 sheet 中Set<String> firstSelectNames = selectTree.keySet();// 都写到第一列，每列最多可以写65535行，写满了再写到第二列，以此类推...// 插入一级下拉框名称数据int rowIndex = 0;int colIndex = 0;Row row = getOrCreateRow(hiddenSheet, rowIndex++);int beginRowIndex = rowIndex + 1;int endRowIndex = 0;String formulaName = "total" + firstSelectNames.size() + "firstSelect";String formulaName_firstSelect = formulaName;row.createCell( colIndex ).setCellValue( formulaName );for( String firstSelectName:firstSelectNames ){row = getOrCreateRow(hiddenSheet, rowIndex++);row.createCell( colIndex ).setCellValue( firstSelectName );}endRowIndex = rowIndex;String colName = getColNameByColIndex(colIndex);String formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );// 插入二级下拉框名称数据for( String firstSelectName:firstSelectNames ){TreeMap<String, List<String>> map_secondSelectName_thirdSelectNames = selectTree.get( firstSelectName );Set<String> secondSelectNames = map_secondSelectName_thirdSelectNames.keySet();row = getOrCreateRow(hiddenSheet, rowIndex++);formulaName = firstSelectName;row.createCell( colIndex ).setCellValue( formulaName );beginRowIndex = rowIndex + 1;for( String secondSelectName:secondSelectNames ){row = getOrCreateRow( hiddenSheet,rowIndex++ );row.createCell( colIndex ).setCellValue( secondSelectName );}endRowIndex = rowIndex;colName = getColNameByColIndex( colIndex );formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );}// 插入三级下拉框名称数据for( String firstSelectName:firstSelectNames ){TreeMap<String, List<String>> map_secondSelectName_thirdSelectNames = selectTree.get( firstSelectName );Set<String> secondSelectNames = map_secondSelectName_thirdSelectNames.keySet();for( String secondSelectName:secondSelectNames ){List<String> thirdSelectNames = map_secondSelectName_thirdSelectNames.get( secondSelectName );if( rowIndex >= XLSX_MAX_ROW_NUM ){rowIndex = 0;colIndex++;}row = getOrCreateRow( hiddenSheet, rowIndex++ );formulaName =  secondSelectName;row.createCell( colIndex ).setCellValue( formulaName );beginRowIndex = rowIndex + 1;for( String thirdSelectName:thirdSelectNames ){row = getOrCreateRow( hiddenSheet, rowIndex++ );row.createCell( colIndex ).setCellValue( thirdSelectName );}endRowIndex = rowIndex;colName = getColNameByColIndex( colIndex );formula = hiddenSheetName + "!$" + colName + "$" + beginRowIndex + ":$" + colName + "$" + endRowIndex;bindFormula( workbook,formulaName,formula );}}XSSFDataValidationHelper helper = new XSSFDataValidationHelper( ( XSSFSheet ) sheet );// 设置第1个下拉框XSSFDataValidationConstraint constraint_firstSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST, formulaName_firstSelect );CellRangeAddressList region_firstSelect = new CellRangeAddressList( 2, XLSX_MAX_ROW_NUM, colIndex_firstSelect, colIndex_firstSelect );XSSFDataValidation validation_firstSelect = (XSSFDataValidation) helper.createValidation( constraint_firstSelect, region_firstSelect );validation_firstSelect.setShowErrorBox( true );sheet.addValidationData( validation_firstSelect );// 设置第2个下拉框colName = getColNameByColIndex( colIndex_firstSelect );String indirect = "INDIRECT($" + colName + "2)";System.out.println( indirect );XSSFDataValidationConstraint constraint_secondSelect = (XSSFDataValidationConstraint) helper.createFormulaListConstraint( indirect );// XSSFDataValidationConstraint constraint_secondSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST,indirect  );CellRangeAddressList region_secondSelect = new CellRangeAddressList( 1, XLSX_MAX_ROW_NUM, colIndex_secondSelect, colIndex_secondSelect );XSSFDataValidation validation_secondSelect = (XSSFDataValidation) helper.createValidation( constraint_secondSelect, region_secondSelect );validation_secondSelect.setShowErrorBox( true );sheet.addValidationData( validation_secondSelect );// 设置第3个下拉框colName = getColNameByColIndex( colIndex_secondSelect );indirect = "INDIRECT($" + colName + "2)";System.out.println( indirect );XSSFDataValidationConstraint constraint_thirdSelect = (XSSFDataValidationConstraint) helper.createFormulaListConstraint( indirect );// XSSFDataValidationConstraint constraint_thirdSelect = new XSSFDataValidationConstraint( DataValidationConstraint.ValidationType.LIST,indirect  );CellRangeAddressList region_thirdSelect = new CellRangeAddressList( 1, XLSX_MAX_ROW_NUM, colIndex_thirdSelect, colIndex_thirdSelect );XSSFDataValidation validation_thirdSelect = (XSSFDataValidation) helper.createValidation( constraint_thirdSelect, region_thirdSelect );validation_thirdSelect.setShowErrorBox( true );sheet.addValidationData( validation_thirdSelect );// 隐藏临时数据sheetint sheetCount = workbook.getNumberOfSheets();for (int i = 0; i < sheetCount; i++) {Sheet currSheet = workbook.getSheetAt(i);if( currSheet.getSheetName().equals( hiddenSheetName ) ){workbook.setSheetHidden(i, true);}}}/**** @param colIndex 0 表示第 1 列* @return*/private static String getColNameByColIndex( int colIndex ) {StringBuilder s = new StringBuilder();while ( colIndex >= 26 ) {s.insert(0, ( char ) ( 'A' + colIndex % 26 ) );colIndex = colIndex / 26 - 1;}s.insert(0, ( char ) ( 'A' + colIndex ) );return s.toString();}private static void bindFormula( Workbook workbook,String formulaName, String formula ) {Name name = workbook.createName();name.setNameName( formulaName );name.setRefersToFormula( formula );System.out.println( "bind \"" + formulaName + "\" for formula \"" + formula + "\"" );}private static Row getOrCreateRow( Sheet sheet,int rowIndex ){Row row = sheet.getRow(rowIndex);if( row != null ){return row;}return sheet.createRow( rowIndex );}private static void insertSelectList( Workbook workbook,Map<ExcelCellRange, List<String>> selectMap) {if( selectMap == null || selectMap.size() == 0 ){return;}Sheet sheet = workbook.getSheetAt(0);if( sheet == null ){return;}Set<ExcelCellRange> excelCellRanges = selectMap.keySet();for( ExcelCellRange excelCellRange:excelCellRanges ){List<String> selectList = selectMap.get( excelCellRange );// 生成下拉框范围CellRangeAddressList cellRangeAddressList = new CellRangeAddressList(excelCellRange.getBeginRow(),excelCellRange.getEndRow(),excelCellRange.getBeginCol(),excelCellRange.getEndCol());// 生成下拉框内容int size = selectList.size();String[] selectArray = new String[ size ];for( int i=0;i<size;i++ ){selectArray[ i ] = selectList.get( i );}XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper((XSSFSheet) sheet);XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper.createExplicitListConstraint( selectArray );XSSFDataValidation xssfDataValidation = (XSSFDataValidation) dvHelper.createValidation( dvConstraint, cellRangeAddressList );sheet.addValidationData( xssfDataValidation );}}/*** 功能描述：Excel导出* @param fileName 文件名称* @param response* @param workbook Excel对象* @return*/public static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {ServletOutputStream outputStream = null;try {response.setCharacterEncoding("UTF-8");response.setHeader("content-Type", "application/octet-stream");response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));outputStream = response.getOutputStream();workbook.write( outputStream );} catch (IOException e) {throw new  RuntimeException(e);}finally {if( workbook != null ){try {workbook.close();}catch ( Exception e ){e.printStackTrace();}}if( outputStream != null ){try {outputStream.close();}catch ( Exception e ){e.printStackTrace();}}}}/*** 功能描述：默认导出方法* @param list 导出的实体集合* @param fileName 导出的文件名* @param response* @return*/private static void defaultExport(List<Map<String, Object>> list, String fileName, HttpServletResponse response) {Workbook workbook = ExcelExportUtil.exportExcel(list, ExcelType.HSSF);if (workbook != null) ;downLoadExcel(fileName, response, workbook);}/*** 功能描述：根据文件路径来导入Excel* @param filePath 文件路径* @param titleRows 表标题的行数* @param headerRows 表头行数* @param pojoClass Excel实体类* @return*/public static <T> List<T> importExcel(String filePath, Integer titleRows, Integer headerRows, Class<T> pojoClass) {//判断文件是否存在if (StringUtils.isBlank(filePath)) {return null;}ImportParams params = new ImportParams();params.setTitleRows(titleRows);params.setHeadRows(headerRows);List<T> list = null;try {list = ExcelImportUtil.importExcel(new File(filePath), pojoClass, params);} catch (NoSuchElementException e) {throw new RuntimeException("模板不能为空");} catch (Exception e) {e.printStackTrace();}return list;}/*** 功能描述：根据接收的Excel文件来导入Excel,并封装成实体类* @param file 上传的文件* @param titleRows 表标题的行数* @param headerRows 表头行数* @param pojoClass Excel实体类* @return*/public static <T> List<T> importExcel(MultipartFile file, Integer titleRows, Integer headerRows, Class<T> pojoClass) {if (file == null) {return null;}ImportParams params = new ImportParams();params.setTitleRows(titleRows);params.setHeadRows(headerRows);List<T> list = null;try {list = ExcelImportUtil.importExcel(file.getInputStream(), pojoClass, params);} catch (NoSuchElementException e) {throw new RuntimeException("excel文件不能为空");} catch (Exception e) {throw new RuntimeException(e.getMessage());}return list;}public static String jointExcelTitleName(String startTime,String endTime, String outType,String titleName){Date startDate = new Date();Date endDate = new Date();try {startDate = TimeNodeUtil.shortSdf.parse(startTime);endDate = TimeNodeUtil.shortSdf.parse(endTime);} catch (ParseException e) {e.printStackTrace();}String startString = TimeNodeUtil.ymdSdf.format(startDate) ;String endString =  TimeNodeUtil.ymdSdf.format(endDate) ;String titleString = "";titleString = titleName+startString+"-"+endString;return titleString;}}

 使用示例：

TreeMap<String, TreeMap<String,List<String>>> selectTree ==null; // todo 自己的三级联动业务数据
ExcelUtils.exportExcelWithThreeCascadeSelect( ${models},${tittle},${sheetName}, XxxModel.class,${fileName},4,5,6,selectTree, response);


http://www.taodudu.cc/news/show-6102282.html

相关文章：

  • 【physx/wasm】在physx中添加自定义接口并重新编译wasm
  • excel---常用操作
  • Lora训练Windows[笔记]
  • linux基础指令讲解（ls、pwd、cd、touch、mkdir）
  • InnoDB 事务处理机制
  • 启明云端ESP32 C3 模组WT32C3通过 MQTT 连接 AWS
  • vue使用Export2Excel.js导出表格自定义样式（表头加分割斜线）（笔记）
  • 前端根据后端返回数据导出指定样式的表格(xlsx-js-style)
  • 使用excelJs.js,导出excel，可以设置序列以及下拉框的联动
  • easy-excel导出excel中日期列需要双击才能进行筛选
  • ExcelJS 导入导出excel带下拉框筛选数据
  • 使用exceljs导出部门-职位联动下拉框的excel
  • 导出excel此单元格中的数字为文本格式,或者其前面有撇号
  • linux查找所有可用的摄像头
  • 树莓派安装mplayer，并使用命令查看摄像头
  • vue获取摄像头
  • 谷歌浏览器获取摄像头
  • 树莓派4b摄像头使能
  • Opencv根据USB摄像头PID\VID号，获取对应摄像头索引
  • rk3588调试之imx415摄像头
  • 推荐用于环境识别的机器人摄像头
  • python opencv 摄像头_opencv python中摄像头参数的设置
  • 树莓派CSI摄像头使用
  • leetcode 968 监控摄像头
  • 根据硬件ID查看摄像头型号方案，可查任何一款摄像头芯片来源
  • android查看摄像头信息,获取Android设备上的详细的摄像头信息
  • python获取摄像头型号_python opencv设置摄像头分辨率以及各个参数的方法_python
  • python获取摄像头型号,python3.6 opencv获取摄像头代码
  • 我的世界服务器自动被踢怎么可以进去,我的世界中国版服务器中如何解决玩家作弊的简单方法...
  • VS2019+WDK10编写xp平台的驱动
  • Windows XP中手动安装驱动程序的方法
  • xp驱动和Win7驱动的区别
  • windows XP 驱动开发环境搭建
  • 戴尔1420装XP方法和驱动
  • window XP驱动开发(一)如何下载WDK
  • Window XP驱动开发(十) 驱动程序的基本结构