cn.afterturn.easypoi.excel.export

Class ExcelExportService

java.lang.Object

cn.afterturn.easypoi.excel.export.base.ExportCommonService

cn.afterturn.easypoi.excel.export.base.BaseExportService

cn.afterturn.easypoi.excel.export.ExcelExportService

Direct Known Subclasses:

ExcelBatchExportService

public class ExcelExportService
extends BaseExportService

Excel导出服务

Author:

JueYue 2014年6月17日 下午5:30:54

Field Summary

Fields inherited from class cn.afterturn.easypoi.excel.export.base.BaseExportService

excelExportStyler, type

Fields inherited from class cn.afterturn.easypoi.excel.export.base.ExportCommonService

dataHandler, dictHandler, LOGGER, needHandlerList

Constructor Summary

Constructors

Constructor and Description
ExcelExportService()

Method Summary

Modifier and Type	Method and Description
protected int	createHeaderAndTitle(ExportParams entity, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook, List<ExcelExportEntity> excelParams)
void	createSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, Class<?> pojoClass, Collection<?> dataSet)
void	createSheetForMap(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> entityList, Collection<?> dataSet)
int	createTitle2Row(ExportParams entity, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook, int fieldWidth) 创建 表头改变
protected void	insertDataToSheet(org.apache.poi.ss.usermodel.Workbook workbook, ExportParams entity, List<ExcelExportEntity> entityList, Collection<?> dataSet, org.apache.poi.ss.usermodel.Sheet sheet)

Methods inherited from class cn.afterturn.easypoi.excel.export.base.BaseExportService

addStatisticsRow, createCells, createDoubleCell, createImageCell, createImageCell, createListCells, createStringCell, getExcelExportStyler, getImageType, getStyles, mergeCells, setCellWith, setColumnHidden, setCurrentIndex, setExcelExportStyler

Methods inherited from class cn.afterturn.easypoi.excel.export.base.ExportCommonService

getAllExcelField, getCellValue, getFieldBySomeMethod, getFieldLength, getListCellValue, getRowHeight, getRowNums, indexExcelEntity, sortAllParams

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelExportService

public ExcelExportService()

Method Detail

createHeaderAndTitle

protected int createHeaderAndTitle(ExportParams entity,
                                   org.apache.poi.ss.usermodel.Sheet sheet,
                                   org.apache.poi.ss.usermodel.Workbook workbook,
                                   List<ExcelExportEntity> excelParams)

createTitle2Row

public int createTitle2Row(ExportParams entity,
                           org.apache.poi.ss.usermodel.Sheet sheet,
                           org.apache.poi.ss.usermodel.Workbook workbook,
                           int fieldWidth)

创建 表头改变

createSheet

public void createSheet(org.apache.poi.ss.usermodel.Workbook workbook,
                        ExportParams entity,
                        Class<?> pojoClass,
                        Collection<?> dataSet)

createSheetForMap

public void createSheetForMap(org.apache.poi.ss.usermodel.Workbook workbook,
                              ExportParams entity,
                              List<ExcelExportEntity> entityList,
                              Collection<?> dataSet)

insertDataToSheet

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