程序包 org.jeecgframework.poi.excel.export

类 ExcelBatchExportServer

java.lang.Object

org.jeecgframework.poi.excel.export.base.ExportBase

org.jeecgframework.poi.excel.export.base.ExcelExportBase

org.jeecgframework.poi.excel.export.ExcelExportServer

org.jeecgframework.poi.excel.export.ExcelBatchExportServer

所有已实现的接口:

IWriter<org.apache.poi.ss.usermodel.Workbook>

public class ExcelBatchExportServer
extends ExcelExportServer
implements IWriter<org.apache.poi.ss.usermodel.Workbook>

提供批次插入服务

作者:

liusq

字段概要

从类继承的字段 org.jeecgframework.poi.excel.export.base.ExcelExportBase

excelExportStyler, type

从类继承的字段 org.jeecgframework.poi.excel.export.base.ExportBase

dataHanlder, dictHandler, needHanlderList

构造器概要

构造器

构造器	说明
ExcelBatchExportServer()

方法概要

修饰符和类型	方法	说明
org.apache.poi.ss.usermodel.Workbook	close()	关闭流,完成业务
List<ExcelExportEntity>	createExcelExportEntityList(ExportParams entity, Class<?> pojoClass)
void	createSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> excelParams)
org.apache.poi.ss.usermodel.Workbook	exportBigExcel(IExcelExportServer server, Object queryParams)
<T> org.apache.poi.ss.usermodel.Workbook	exportBigExcelEnhanced(IExcelExportServerEnhanced<T> server, Object queryParams)	大数据导出 - 游标分页方式 推荐用于大数据量（20万+）导出,避免深分页性能问题 for [QQYUN-13964]演示系统数据量大，点击没反应 实现原理: 1.
org.apache.poi.ss.usermodel.Workbook	get()	获取输出对象
ExcelExportEntity	indexExcelEntity(ExportParams entity)	添加Index列
void	init(ExportParams entity, Class<?> pojoClass)
void	init(ExportParams entity, List<ExcelExportEntity> excelParams)	初始化数据
protected void	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
IWriter<org.apache.poi.ss.usermodel.Workbook>	write(Collection data)	写入数据

从类继承的方法 org.jeecgframework.poi.excel.export.ExcelExportServer

createHeaderAndTitle, createHeaderRow, createSheet, createSheetForMap

从类继承的方法 org.jeecgframework.poi.excel.export.base.ExcelExportBase

addStatisticsRow, createCells, createCells, createImageCell, createListCells, createNumericCell, createStringCell, getExcelExportStyler, getFieldWidth, getImageType, getListCellSize, getStyles, mergeCells, setCellWith, setColumnHidden, setCurrentIndex, setExcelExportStyler

从类继承的方法 org.jeecgframework.poi.excel.export.base.ExportBase

getAllExcelField, getCellOrder, getCellValue, getExcelName, getFieldBySomeMethod, getListCellValue, getRowHeight, getValueArr, isInteger, reConfigExcelExportParams, sortAllParams

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

ExcelBatchExportServer

public ExcelBatchExportServer()

方法详细资料

init

public void init(ExportParams entity,
 Class<?> pojoClass)

init

public void init(ExportParams entity,
 List<ExcelExportEntity> excelParams)

初始化数据

参数:

entity - 导出参数

excelParams -

createExcelExportEntityList

public List<ExcelExportEntity> createExcelExportEntityList(ExportParams entity,
 Class<?> pojoClass)

createSheet

public void createSheet(org.apache.poi.ss.usermodel.Workbook workbook,
 ExportParams entity,
 List<ExcelExportEntity> excelParams)

insertDataToSheet

protected void insertDataToSheet(org.apache.poi.ss.usermodel.Workbook workbook,
 ExportParams entity,
 List<ExcelExportEntity> entityList,
 Collection<? extends Map<?,?>> dataSet,
 org.apache.poi.ss.usermodel.Sheet sheet)

从类复制的说明: ExcelExportServer

添加数据到sheet

覆盖:

insertDataToSheet 在类中 ExcelExportServer

entity - 导出参数

dataSet - 导出数据

exportBigExcel

public org.apache.poi.ss.usermodel.Workbook exportBigExcel(IExcelExportServer server,
 Object queryParams)

exportBigExcelEnhanced

public <T> org.apache.poi.ss.usermodel.Workbook exportBigExcelEnhanced(IExcelExportServerEnhanced<T> server,
 Object queryParams)

大数据导出 - 游标分页方式 推荐用于大数据量（20万+）导出,避免深分页性能问题 for [QQYUN-13964]演示系统数据量大，点击没反应 实现原理: 1. 使用上一批次的最后一条记录作为查询起点 2. 避免 LIMIT offset, size 造成的性能衰减 3. 查询速度恒定,不会随着数据量增加而变慢

参数:

server - 增强的查询服务

queryParams - 查询参数

返回:

Workbook

get

public org.apache.poi.ss.usermodel.Workbook get()

从接口复制的说明: IWriter

获取输出对象

指定者:

get 在接口中 IWriter<org.apache.poi.ss.usermodel.Workbook>

返回:

write

public IWriter<org.apache.poi.ss.usermodel.Workbook> write(Collection data)

从接口复制的说明: IWriter

写入数据

指定者:

write 在接口中 IWriter<org.apache.poi.ss.usermodel.Workbook>

返回:

close

public org.apache.poi.ss.usermodel.Workbook close()

从接口复制的说明: IWriter

关闭流,完成业务

指定者:

close 在接口中 IWriter<org.apache.poi.ss.usermodel.Workbook>

返回:

indexExcelEntity

public ExcelExportEntity indexExcelEntity(ExportParams entity)

添加Index列

覆盖:

indexExcelEntity 在类中 ExcelExportServer