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

Class SimpleUstraExcelCellGenerator

java.lang.Object

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

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

Direct Known Subclasses:

ColoredHeaderUstraExcelCellGenerator

public class SimpleUstraExcelCellGenerator
extends UstraExcelCellGenerator

기본 UstraExcelCellGenerator

Constructor Summary

Constructors

Constructor and Description
SimpleUstraExcelCellGenerator()

Method Summary

Modifier and Type	Method and Description
protected void	bindBodyCellValue(org.apache.poi.ss.usermodel.Row row, int colIndex, java.lang.Object src, UstraExcelCellInfoModel cellInfo) Cell 값 바인딩
void	customizeSheet(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) cell 생성 완료 후, workbook / sheet customize
void	init(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet) 초기화 수행
void	makeBody(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) Body 생성
void	makeFooter(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) Footer 생성
void	makeHeader(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) 헤더 생성
void	makeTitle(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model) 타이틀 영역 생성
protected static java.lang.String	nvl(java.lang.Object src) null vlaue 값을 공백으로 치환

Methods inherited from class com.gsitm.ustra.java.data.poi.generator.UstraExcelCellGenerator

addCellStyle, addCurrentRow, createRow, getBodyData, getCellStyle, getCellStyleMap, getCurrentRow

Methods inherited from class java.lang.Object

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

Constructor Detail

SimpleUstraExcelCellGenerator

public SimpleUstraExcelCellGenerator()

Method Detail

init

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

Description copied from class: UstraExcelCellGenerator

초기화 수행

Specified by:

init in class UstraExcelCellGenerator

makeTitle

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

Description copied from class: UstraExcelCellGenerator

타이틀 영역 생성

Specified by:

makeTitle in class UstraExcelCellGenerator

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

makeHeader

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

Description copied from class: UstraExcelCellGenerator

헤더 생성

Specified by:

makeHeader in class UstraExcelCellGenerator

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

makeBody

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

Description copied from class: UstraExcelCellGenerator

Body 생성

Specified by:

makeBody in class UstraExcelCellGenerator

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

bindBodyCellValue

protected void bindBodyCellValue(org.apache.poi.ss.usermodel.Row row,
                                 int colIndex,
                                 java.lang.Object src,
                                 UstraExcelCellInfoModel cellInfo)

Cell 값 바인딩

Parameters:

row - Row

colIndex -

src - 원본 데이터 값

cellInfo - cell 정보

nvl

protected static java.lang.String nvl(java.lang.Object src)

null vlaue 값을 공백으로 치환

Parameters:

src -

Returns:

makeFooter

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

Description copied from class: UstraExcelCellGenerator

Footer 생성

Specified by:

makeFooter in class UstraExcelCellGenerator

Parameters:

workbook - 워크북

sheet - Sheet

model - UstraExcelModel

customizeSheet

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

Description copied from class: UstraExcelCellGenerator

cell 생성 완료 후, workbook / sheet customize

Specified by:

customizeSheet in class UstraExcelCellGenerator

Parameters:

workbook - 워크북

sheet - Sheet