com.gsitm.ustra.java.data.poi

Class UstraExcelUtils

java.lang.Object

com.gsitm.ustra.java.data.poi.UstraExcelUtils

public final class UstraExcelUtils
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	UstraExcelUtils.RowInfo

Field Summary

Fields

Modifier and Type	Field and Description
static int	BUFFER_SIZE

Method Summary

Modifier and Type	Method and Description
static UstraExcelWorkbook	createSheet(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) Deprecated.
static java.io.InputStream	decrypt(java.io.InputStream inputStream, java.lang.String password) Deprecated.
static java.util.List<UstraExcelLoadFailureInfo>	getFailureInfo(java.util.List<UstraExcelUtils.RowInfo> rows) Deprecated. UstraExcelReader.getFailureInfo 사용
static java.util.Map<java.lang.Object,java.util.List<UstraExcelUtils.RowInfo>>	loadMultiSheets(UstraExcelDecodingOption option) Multi Sheet Excel 파일을 로드하여 Data 객체로 변환한다.
static java.util.List<UstraExcelUtils.RowInfo>	loadSheet(java.io.InputStream in, java.lang.Class<?> clazz, boolean stopOnError) Deprecated.
static java.util.List<UstraExcelUtils.RowInfo>	loadSheet(UstraExcelDecodingOption option) Excel 파일을 로드하여 Data 객체로 변환한다.
static java.util.List<UstraExcelUtils.RowInfo>	loadSheetFilePath(java.lang.String path, java.lang.Class<?> clazz, boolean stopOnError) Deprecated.
static void	saveSheet(java.io.OutputStream output, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) Deprecated.
static <T> void	saveSheet(java.io.OutputStream output, java.util.List<T> data, java.lang.Class<T> clazz) Deprecated.
static <T> void	saveSheet(java.io.OutputStream output, java.util.List<T> data, java.util.List<UstraExcelCellInfoModel> cells, java.lang.Class<T> clazz) Deprecated.
static void	saveSheet(java.io.OutputStream output, java.lang.String password, java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data, java.util.List<UstraExcelCellInfoModel> cells) Deprecated.
static <T> void	saveSheet(java.io.OutputStream output, java.lang.String password, java.util.List<T> data, java.lang.Class<T> clazz) Deprecated.
static <T> void	saveSheet(java.io.OutputStream output, java.lang.String password, java.util.List<T> data, java.util.List<UstraExcelCellInfoModel> cells, java.lang.Class<T> clazz) Deprecated.
static void	saveSheet(java.io.OutputStream output, java.lang.String password, UstraExcelWorkbook workbook) Deprecated.
static void	saveSheet(java.io.OutputStream output, UstraExcelWorkbook workbook) Deprecated.
static void	saveSheet(UstraExcelWorkbook workbook, java.io.OutputStream output, java.lang.String password)
static void	saveWorkbook(UstraExcelWorkbook workbook, java.io.OutputStream outputStream)

Methods inherited from class java.lang.Object

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

Field Detail

BUFFER_SIZE

public static final int BUFFER_SIZE

See Also:

Constant Field Values

Method Detail

loadSheet

public static java.util.List<UstraExcelUtils.RowInfo> loadSheet(UstraExcelDecodingOption option)

Excel 파일을 로드하여 Data 객체로 변환한다.

Parameters:

option - 변환 옵션

Returns:

파일 리딩 결과

loadMultiSheets

public static java.util.Map<java.lang.Object,java.util.List<UstraExcelUtils.RowInfo>> loadMultiSheets(UstraExcelDecodingOption option)

Multi Sheet Excel 파일을 로드하여 Data 객체로 변환한다.

Parameters:

option - 변환 옵션

Returns:

파일 리딩 결과

loadSheet

public static java.util.List<UstraExcelUtils.RowInfo> loadSheet(java.io.InputStream in,
                                                                java.lang.Class<?> clazz,
                                                                boolean stopOnError)

Deprecated.

Excel 파일을 로드하여 Data 객체로 변환한다.

Parameters:

in - stream

clazz - 변환 클래스

stopOnError - 오류 발생 시 중지 여부

Returns:

파일 리딩 결과

loadSheetFilePath

public static java.util.List<UstraExcelUtils.RowInfo> loadSheetFilePath(java.lang.String path,
                                                                        java.lang.Class<?> clazz,
                                                                        boolean stopOnError)

Deprecated.

지정 파일 경로의 엑셀을 리딩한다.

Parameters:

path - 파일 경로

clazz - 대상 클래스

stopOnError - 오류시 중지 여부

Returns:

getFailureInfo

public static java.util.List<UstraExcelLoadFailureInfo> getFailureInfo(java.util.List<UstraExcelUtils.RowInfo> rows)

Deprecated. UstraExcelReader.getFailureInfo 사용

엑셀 리딩 결과에서 실패 정보 리딩

Parameters:

rows -

Returns:

createSheet

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

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static void saveSheet(java.io.OutputStream output,
                                         java.lang.String password,
                                         UstraExcelWorkbook workbook)
                                  throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

public static void saveSheet(UstraExcelWorkbook workbook,
                             java.io.OutputStream output,
                             java.lang.String password)
                      throws java.lang.Exception

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static void saveSheet(java.io.OutputStream output,
                                         UstraExcelWorkbook workbook)
                                  throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveWorkbook

public static void saveWorkbook(UstraExcelWorkbook workbook,
                                java.io.OutputStream outputStream)
                         throws java.io.IOException

Throws:

java.io.IOException

saveSheet

@Deprecated
public static void saveSheet(java.io.OutputStream output,
                                         java.lang.String password,
                                         java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                                         java.util.List<UstraExcelCellInfoModel> cells)
                                  throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static void saveSheet(java.io.OutputStream output,
                                         java.util.List<java.util.Map<java.lang.String,java.lang.Object>> data,
                                         java.util.List<UstraExcelCellInfoModel> cells)
                                  throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static <T> void saveSheet(java.io.OutputStream output,
                                             java.lang.String password,
                                             java.util.List<T> data,
                                             java.util.List<UstraExcelCellInfoModel> cells,
                                             java.lang.Class<T> clazz)
                                      throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static <T> void saveSheet(java.io.OutputStream output,
                                             java.util.List<T> data,
                                             java.util.List<UstraExcelCellInfoModel> cells,
                                             java.lang.Class<T> clazz)
                                      throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static <T> void saveSheet(java.io.OutputStream output,
                                             java.lang.String password,
                                             java.util.List<T> data,
                                             java.lang.Class<T> clazz)
                                      throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

saveSheet

@Deprecated
public static <T> void saveSheet(java.io.OutputStream output,
                                             java.util.List<T> data,
                                             java.lang.Class<T> clazz)
                                      throws java.lang.Exception

Deprecated.

Throws:

java.lang.Exception

decrypt

public static java.io.InputStream decrypt(java.io.InputStream inputStream,
                                          java.lang.String password)

Deprecated.

inputstream 엑셀을 decrypt한다

Parameters:

inputStream - inputStream

password - password

Returns:

decrypted 된 엑셀 파일