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

Class UstraExcelUtils

java.lang.Object

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

public final class UstraExcelUtils
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	UstraExcelUtils.RowInfo

Field Summary

Fields

Modifier and Type	Field	Description
static final int	BUFFER_SIZE

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Details

BUFFER_SIZE

public static final int BUFFER_SIZE

See Also:

• Constant Field Values

Method Details

loadSheet

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

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

Parameters:

option - 변환 옵션

Returns:

파일 리딩 결과

loadMultiSheets

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

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

Parameters:

option - 변환 옵션

Returns:

파일 리딩 결과

loadSheet

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

Deprecated.

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

Parameters:

in - stream

clazz - 변환 클래스

stopOnError - 오류 발생 시 중지 여부

Returns:

파일 리딩 결과

loadSheetFilePath

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

Deprecated.

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

Parameters:

path - 파일 경로

clazz - 대상 클래스

stopOnError - 오류시 중지 여부

Returns:

getFailureInfo

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

Deprecated.

UstraExcelReader.getFailureInfo 사용

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

Parameters:

rows -

Returns:

createSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

public static void saveSheet(UstraExcelWorkbook workbook,
 OutputStream output,
 String password)
                      throws Exception

Throws:

Exception

saveSheet

@Deprecated
public static void saveSheet(OutputStream output,
 UstraExcelWorkbook workbook)
                      throws Exception

Deprecated.

Throws:

Exception

saveWorkbook

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

Throws:

IOException

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

saveSheet

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

Deprecated.

Throws:

Exception

decrypt

public static InputStream decrypt(InputStream inputStream,
 String password)

Deprecated.

inputstream 엑셀을 decrypt한다

Parameters:

inputStream - inputStream

password - password

Returns:

decrypted 된 엑셀 파일