com.gsitm.ustra.java.data.poi.generator

Class UstraExcelCellGenerator

java.lang.Object

com.gsitm.ustra.java.data.poi.generator.UstraExcelCellGenerator

Direct Known Subclasses:

SimpleUstraExcelCellGenerator

public abstract class UstraExcelCellGenerator
extends java.lang.Object

데이터를 엑셀 셀로 변환하는 generator

Constructor Summary

Constructors

Constructor and Description
UstraExcelCellGenerator()

Method Summary

Modifier and Type	Method and Description
protected void	addCellStyle(java.lang.String key, org.apache.poi.ss.usermodel.CellStyle value) cell style을 추가
void	addCurrentRow() 현재 row 값을 증가
protected org.apache.poi.xssf.streaming.SXSSFRow	createRow(org.apache.poi.xssf.streaming.SXSSFSheet sheet) sheet에 row를 신규 생성
abstract void	customizeSheet(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) cell 생성 완료 후, workbook / sheet customize
protected java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	getBodyData(UstraExcelModel model, int index) Body에 바인딩할 데이터를 조회한다.
protected org.apache.poi.ss.usermodel.CellStyle	getCellStyle(java.lang.String key) cell style 조회
java.util.Map<java.lang.String,org.apache.poi.ss.usermodel.CellStyle>	getCellStyleMap()
int	getCurrentRow()
abstract void	init(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet) 초기화 수행
abstract void	makeBody(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) Body 생성
abstract void	makeFooter(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) Footer 생성
abstract void	makeHeader(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) 헤더 생성
abstract void	makeTitle(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) 타이틀 영역 생성

Methods inherited from class java.lang.Object

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

Constructor Detail

UstraExcelCellGenerator

public UstraExcelCellGenerator()

Method Detail

addCellStyle

protected void addCellStyle(java.lang.String key,
                            org.apache.poi.ss.usermodel.CellStyle value)

cell style을 추가

Parameters:

key - key 값

value - cellStyle

getCellStyle

protected org.apache.poi.ss.usermodel.CellStyle getCellStyle(java.lang.String key)

cell style 조회

Parameters:

key - 키 값

init

public abstract void init(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                          org.apache.poi.xssf.streaming.SXSSFSheet sheet)

초기화 수행

makeTitle

public abstract void makeTitle(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                               org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                               UstraExcelModel model)

타이틀 영역 생성

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

makeHeader

public abstract void makeHeader(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                                org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                                UstraExcelModel model)

헤더 생성

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

makeBody

public abstract void makeBody(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                              org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                              UstraExcelModel model)

Body 생성

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

getBodyData

protected java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getBodyData(UstraExcelModel model,
                                                                                       int index)

Body에 바인딩할 데이터를 조회한다. UstraExcelWorksheetDataProvider 옵션 추가로 body data 조회 처리 추가

Parameters:

model - UstraExcelModel

index - 조회 순번

makeFooter

public abstract void makeFooter(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                                org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                                UstraExcelModel model)

Footer 생성

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

customizeSheet

public abstract void customizeSheet(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook,
                                    org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                                    UstraExcelModel model)

cell 생성 완료 후, workbook / sheet customize

Parameters:

workbook - 워크북

sheet - Sheet

createRow

protected org.apache.poi.xssf.streaming.SXSSFRow createRow(org.apache.poi.xssf.streaming.SXSSFSheet sheet)

sheet에 row를 신규 생성

Parameters:

sheet - sheet

Returns:

엑셀 Row

addCurrentRow

public void addCurrentRow()

현재 row 값을 증가

getCellStyleMap

public java.util.Map<java.lang.String,org.apache.poi.ss.usermodel.CellStyle> getCellStyleMap()

getCurrentRow

public int getCurrentRow()