Package com.gsitm.ustra.java.data.poi

Class UstraExcelWorkbook

java.lang.Object

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

public class UstraExcelWorkbook
extends Object

엑셀 워크북

Field Summary

Fields

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

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	addRows(List<Map<String,Object>> data)	Deprecated.
void	close()	Workbook 객체를 close
static UstraExcelWorkbook	create(int buffer, List<Map<String,Object>> data, List<UstraExcelCellInfoModel> cells)	UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(UstraExcelModel model)	UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(List<UstraExcelModel> models)	UstraExcelWorkbook 생성
static UstraExcelWorkbook	create(List<Map<String,Object>> data, List<UstraExcelCellInfoModel> cells)	UstraExcelWorkbook 생성
static <T> UstraExcelWorkbook	create(List<T> data, Class<T> clazz)	UstraExcelWorkbook 생성
static <T> UstraExcelWorkbook	create(List<T> data, List<UstraExcelCellInfoModel> cells, Class<T> clazz)	UstraExcelWorkbook 생성
protected void	generate()	Workbook Cell을 generate
void	write(OutputStream output)	Workbook을 OutputStream에 write한다.
void	writeAndClose(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 Details

BUFFER_SIZE

public static int BUFFER_SIZE

workbook

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

Workbook

models

protected List<UstraExcelModel> models

모델 목록

Constructor Details

UstraExcelWorkbook

protected UstraExcelWorkbook(UstraExcelModel model)
                      throws Exception

Throws:

Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(List<UstraExcelModel> models)
                      throws Exception

Throws:

Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(List<UstraExcelModel> models,
 int buffer)
                      throws Exception

Throws:

Exception

UstraExcelWorkbook

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

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

Throws:

Exception

UstraExcelWorkbook

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

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

buffer - 버퍼 사이즈

Throws:

Exception

UstraExcelWorkbook

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

Deprecated.

UstraExcelWorkbook 생성

Parameters:

buffer - 버퍼

data - 데이터 목록

cells - cell 목록

Throws:

Exception

UstraExcelWorkbook

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

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

cells - cell 목록

clazz - 데이터 클래스 유형

Throws:

Exception

UstraExcelWorkbook

protected UstraExcelWorkbook(List<T> data,
 Class<T> clazz)
                      throws Exception

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

clazz - cell 목록

Throws:

Exception - 데이터 클래스 유형

UstraExcelWorkbook

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

UstraExcelWorkbook 생성

Type Parameters:

T - 데이터 유형

Parameters:

provider - UstraExcelWorksheetDataProvider 객체

cells - 셀목록

clazz - 클래스

Throws:

Exception

UstraExcelWorkbook

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

UstraExcelWorkbook 생성

Type Parameters:

T - 데이터 유형

Parameters:

provider - UstraExcelWorksheetDataProvider 객체

clazz - 클래스

Throws:

Exception

Method Details

generate

protected void generate()

Workbook Cell을 generate

addRows

public void addRows(List<Map<String,Object>> data)
             throws Exception

Deprecated.

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

Parameters:

data - 데이터

Throws:

Exception

write

public void write(OutputStream output)
           throws IOException

Workbook을 OutputStream에 write한다.

Parameters:

output -

Throws:

IOException

close

public void close()
           throws IOException

Workbook 객체를 close

Throws:

IOException

writeAndClose

public void writeAndClose(OutputStream output)
                   throws IOException

Workbook을 OutputStream에 write하고 close

Parameters:

output -

Throws:

IOException

create

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

UstraExcelWorkbook 생성

Parameters:

buffer - 버퍼 사이즈

data - 데이터 목록

cells - cell 목록

Returns:

UstraExcelWorkbook

Throws:

Exception

create

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

UstraExcelWorkbook 생성

Parameters:

data - 데이터 목록

cells - cell 목록

Returns:

UstraExcelWorkbook

Throws:

Exception

create

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

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

cells - cell 목록

clazz - 데이터 유형 클래스

Returns:

UstraExcelWorkbook

Throws:

Exception

create

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

UstraExcelWorkbook 생성

Type Parameters:

T -

Parameters:

data - 데이터 목록

clazz - 데이터 유형 클래스

Returns:

UstraExcelWorkbook

Throws:

Exception

create

public static UstraExcelWorkbook create(UstraExcelModel model)
                                 throws Exception

UstraExcelWorkbook 생성

Parameters:

model - UstraExcelModel

Returns:

UstraExcelWorkbook

Throws:

Exception

create

public static UstraExcelWorkbook create(List<UstraExcelModel> models)
                                 throws Exception

UstraExcelWorkbook 생성

Parameters:

model - UstraExcelModel

Returns:

UstraExcelWorkbook

Throws:

Exception