类的使用
org.jeecgframework.poi.excel.entity.ExportParams
使用ExportParams的程序包
程序包
说明
-
org.jeecgframework.poi.excel中ExportParams的使用
参数类型为ExportParams的org.jeecgframework.poi.excel中的方法修饰符和类型方法说明static IWriter<org.apache.poi.ss.usermodel.Workbook>ExcelExportUtil.exportBigExcel(ExportParams entity, Class<?> pojoClass) 大数据量导出static org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportBigExcel(ExportParams entity, Class<?> pojoClass, IExcelExportServer server, Object queryParams) 大数据量导出static IWriter<org.apache.poi.ss.usermodel.Workbook>ExcelExportUtil.exportBigExcel(ExportParams entity, List<ExcelExportEntity> excelParams) 大数据量导出static org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportBigExcel(ExportParams entity, List<ExcelExportEntity> excelParams, IExcelExportServer server, Object queryParams) 大数据量导出static <T> org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportBigExcelEnhanced(ExportParams entity, Class<T> pojoClass, IExcelExportServerEnhanced<T> server, Object queryParams) 大数据量导出 - 高性能游标分页方案 for [QQYUN-13964]演示系统数据量大,点击没反应static <T> org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportBigExcelEnhanced(ExportParams entity, List<ExcelExportEntity> excelParams, IExcelExportServerEnhanced<T> server, Object queryParams) 大数据量导出 - 高性能游标分页方案(自定义列)static org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportExcel(ExportParams entity, Class<?> pojoClass, Collection<?> dataSet) 根据Entity创建对应的Excelstatic org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportExcel(ExportParams entity, Class<?> pojoClass, Collection<?> dataSet, String[] exportFields) 根据Entity创建对应的Excelstatic org.apache.poi.ss.usermodel.WorkbookExcelExportUtil.exportExcel(ExportParams entity, List<ExcelExportEntity> entityList, Collection<? extends Map<?, ?>> dataSet) 根据Map创建对应的Excel -
org.jeecgframework.poi.excel.export中ExportParams的使用
修饰符和类型方法说明ExcelBatchExportServer.createExcelExportEntityList(ExportParams entity, Class<?> pojoClass) protected intExcelExportServer.createHeaderAndTitle(ExportParams entity, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook, List<ExcelExportEntity> excelParams) intExcelExportServer.createHeaderRow(ExportParams entity, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook, int feildWidth) 创建 表头改变voidExcelBatchExportServer.createSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> excelParams) voidExcelExportServer.createSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, Class<?> pojoClass, Collection<?> dataSet, String[] exportFields) voidExcelExportServer.createSheetForMap(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> entityList, Collection<? extends Map<?, ?>> dataSet) ExcelBatchExportServer.indexExcelEntity(ExportParams entity) 添加Index列protected ExcelExportEntityExcelExportServer.indexExcelEntity(ExportParams entity) voidExcelBatchExportServer.init(ExportParams entity, Class<?> pojoClass) voidExcelBatchExportServer.init(ExportParams entity, List<ExcelExportEntity> excelParams) 初始化数据protected voidExcelBatchExportServer.insertDataToSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> entityList, Collection<? extends Map<?, ?>> dataSet, org.apache.poi.ss.usermodel.Sheet sheet) protected voidExcelExportServer.insertDataToSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> entityList, Collection<? extends Map<?, ?>> dataSet, org.apache.poi.ss.usermodel.Sheet sheet) 添加数据到sheet -
org.jeecgframework.poi.excel.export.base中ExportParams的使用
修饰符和类型方法说明voidExportBase.reConfigExcelExportParams(List<ExcelExportEntity> excelParams, ExportParams exportParams) 循环ExcelExportEntity集合 附加配置信息
1.列排序
2.读取图片根路径设置(如果有字段是图片类型 并且存储在本地 则设置磁盘路径获取全地址导出)
3.多表头配置(仅限于单表 会走这个逻辑处理)