com.gsitm.ustra.java.data.poi

Class UstraExcelWorkbook

java.lang.Object

com.gsitm.ustra.java.data.poi.UstraExcelWorkbook

public class UstraExcelWorkbook
extends java.lang.Object

엑셀 워크북

Field Summary

Fields

Modifier and Type	Field and Description
static int	BUFFER_SIZE
protected java.util.List<UstraExcelModel>	models 모델 목록
protected org.apache.poi.xssf.streaming.SXSSFWorkbook	workbook Workbook

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	UstraExcelWorkbook(int buffer, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) Deprecated.
protected	UstraExcelWorkbook(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) UstraExcelWorkbook 생성
protected	UstraExcelWorkbook(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells, int buffer) UstraExcelWorkbook 생성
protected	UstraExcelWorkbook(java.util.List<T> data, java.lang.Class<T> clazz) UstraExcelWorkbook 생성
protected	UstraExcelWorkbook(java.util.List<T> data, java.util.List<UstraExcelCellInfoModel> cells, java.lang.Class<T> clazz) UstraExcelWorkbook 생성
protected	UstraExcelWorkbook(java.util.List<UstraExcelModel> models)
protected	UstraExcelWorkbook(java.util.List<UstraExcelModel> models, int buffer)
protected	UstraExcelWorkbook(UstraExcelModel model)
protected	UstraExcelWorkbook(UstraExcelWorksheetDataProvider<T> provider, java.lang.Class<T> clazz) UstraExcelWorkbook 생성
protected	UstraExcelWorkbook(UstraExcelWorksheetDataProvider<T> provider, java.util.List<UstraExcelCellInfoModel> cells, java.lang.Class<T> clazz) UstraExcelWorkbook 생성

Method Summary

Modifier and Type	Method and Description
void	addRows(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data) Deprecated.
void	close() Workbook 객체를 close
static UstraExcelWorkbook	create(int buffer, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) UstraExcelWorkbook 생성
static <T> UstraExcelWorkbook	create(java.util.List<T> data, java.lang.Class<T> clazz) UstraExcelWorkbook 생성
static <T> UstraExcelWorkbook	create(java.util.List<T> data, java.util.List<UstraExcelCellInfoModel> cells, java.lang.Class<T> clazz) UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(java.util.List<UstraExcelModel> models) UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(UstraExcelModel model) UstraExcelWorkbook 생성
protected void	generate() Workbook Cell을 generate
void	write(java.io.OutputStream output) Workbook을 OutputStream에 write한다.
void	writeAndClose(java.io.OutputStream output) Workbook을 OutputStream에 write하고 close

Methods inherited from class java.lang.Object

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

Field Detail

BUFFER_SIZE

public static int BUFFER_SIZE

workbook

protected org.apache.poi.xssf.streaming.SXSSFWorkbook workbook

Workbook

models

protected java.util.List<UstraExcelModel> models

모델 목록

Constructor Detail

UstraExcelWorkbook

protected UstraExcelWorkbook(UstraExcelModel model)
                      throws java.lang.Exception

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<UstraExcelModel> models)
                      throws java.lang.Exception

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<UstraExcelModel> models,
                             int buffer)
                      throws java.lang.Exception

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                             java.util.List<UstraExcelCellInfoModel> cells)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                             java.util.List<UstraExcelCellInfoModel> cells,
                             int buffer)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

buffer - 버퍼 사이즈

Throws:

java.lang.Exception

UstraExcelWorkbook

@Deprecated
protected UstraExcelWorkbook(int buffer,
                                         java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                                         java.util.List<UstraExcelCellInfoModel> cells)
                                  throws java.lang.Exception

Deprecated.

UstraExcelWorkbook 생성

Parameters:

buffer - 버퍼

data - 데이터 목록

cells - cell 목록

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<T> data,
                             java.util.List<UstraExcelCellInfoModel> cells,
                             java.lang.Class<T> clazz)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

cells - cell 목록

clazz - 데이터 클래스 유형

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(java.util.List<T> data,
                             java.lang.Class<T> clazz)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

clazz - cell 목록

Throws:

java.lang.Exception - 데이터 클래스 유형

UstraExcelWorkbook

protected UstraExcelWorkbook(UstraExcelWorksheetDataProvider<T> provider,
                             java.util.List<UstraExcelCellInfoModel> cells,
                             java.lang.Class<T> clazz)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T - 데이터 유형

Parameters:

provider - UstraExcelWorksheetDataProvider 객체

cells - 셀목록

clazz - 클래스

Throws:

java.lang.Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(UstraExcelWorksheetDataProvider<T> provider,
                             java.lang.Class<T> clazz)
                      throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T - 데이터 유형

Parameters:

provider - UstraExcelWorksheetDataProvider 객체

clazz - 클래스

Throws:

java.lang.Exception

Method Detail

generate

protected void generate()

Workbook Cell을 generate

addRows

public void addRows(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data)
             throws java.lang.Exception

Deprecated.

첫번째 시트에 추가 데이터를 추가한다.

Parameters:

data - 데이터

Throws:

java.lang.Exception

write

public void write(java.io.OutputStream output)
           throws java.io.IOException

Workbook을 OutputStream에 write한다.

Parameters:

output -

Throws:

java.io.IOException

close

public void close()
           throws java.io.IOException

Workbook 객체를 close

Throws:

java.io.IOException

writeAndClose

public void writeAndClose(java.io.OutputStream output)
                   throws java.io.IOException

Workbook을 OutputStream에 write하고 close

Parameters:

output -

Throws:

java.io.IOException

create

public static UstraExcelWorkbook create(int buffer,
                                        java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                                        java.util.List<UstraExcelCellInfoModel> cells)
                                 throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

buffer - 버퍼 사이즈

data - 데이터 목록

cells - cell 목록

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception

create

public static UstraExcelWorkbook create(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                                        java.util.List<UstraExcelCellInfoModel> cells)
                                 throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception

create

public static <T> UstraExcelWorkbook create(java.util.List<T> data,
                                            java.util.List<UstraExcelCellInfoModel> cells,
                                            java.lang.Class<T> clazz)
                                     throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

cells - cell 목록

clazz - 데이터 유형 클래스

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception

create

public static <T> UstraExcelWorkbook create(java.util.List<T> data,
                                            java.lang.Class<T> clazz)
                                     throws java.lang.Exception

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

clazz - 데이터 유형 클래스

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception

create

public static UstraExcelWorkbook create(UstraExcelModel model)
                                 throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

model - UstraExcelModel

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception

create

public static UstraExcelWorkbook create(java.util.List<UstraExcelModel> models)
                                 throws java.lang.Exception

UstraExcelWorkbook 생성

Parameters:

model - UstraExcelModel

Returns:

UstraExcelWorkbook

Throws:

java.lang.Exception