com.gsitm.ustra.java.data.poi

Class UstraExcelParser

java.lang.Object

com.gsitm.ustra.java.data.poi.UstraExcelParser

All Implemented Interfaces:

org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

public class UstraExcelParser
extends java.lang.Object
implements org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

Excel Parsing 처리

Constructor Summary

Constructors

Constructor and Description
UstraExcelParser()

Method Summary

Modifier and Type	Method and Description
void	cell(short columnIndex, java.lang.String value, org.apache.poi.ss.usermodel.Comment comment) cell 정보 parsing
void	cell(java.lang.String columnName, java.lang.String value, org.apache.poi.xssf.usermodel.XSSFComment comment)
protected UstraExcelCellDecoder	createDecoder(java.lang.String decoderClassName) decoder 인스턴스 생성
void	endRow(int rowNum)
java.lang.Class<?>	getClazz() 클래스 목록
int	getHeaderRowIndex() 헤더 정보 추출을 위한 index
java.util.List<UstraExcelUtils.RowInfo>	getRows() row 목록
void	headerFooter(java.lang.String text, boolean isHeader, java.lang.String tagName)
void	initialize(java.lang.Class<?> clazz, boolean stopOnError, int headerRowIndex)
boolean	isStopOnError() 오류 시 중지 여부
protected java.lang.Object	parseRowAsEntity(int rowNum) row를 entity로 parsing
protected java.util.Map<java.lang.String,java.lang.Object>	parseRowAsMap(int rowNum) row를 map으로 parsing
void	startRow(int rowNum)

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

endSheet

Constructor Detail

UstraExcelParser

public UstraExcelParser()

Method Detail

initialize

public void initialize(java.lang.Class<?> clazz,
                       boolean stopOnError,
                       int headerRowIndex)

startRow

public void startRow(int rowNum)

Specified by:

startRow in interface org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

headerFooter

public void headerFooter(java.lang.String text,
                         boolean isHeader,
                         java.lang.String tagName)

Specified by:

headerFooter in interface org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

endRow

public void endRow(int rowNum)

Specified by:

endRow in interface org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

parseRowAsEntity

protected java.lang.Object parseRowAsEntity(int rowNum)

row를 entity로 parsing

Parameters:

rowNum - row 번호

Returns:

entity instance

parseRowAsMap

protected java.util.Map<java.lang.String,java.lang.Object> parseRowAsMap(int rowNum)

row를 map으로 parsing

Parameters:

rowNum - row 번호

Returns:

map instance

createDecoder

protected UstraExcelCellDecoder createDecoder(java.lang.String decoderClassName)

decoder 인스턴스 생성

Parameters:

decoderClassName -

Returns:

cell

public void cell(java.lang.String columnName,
                 java.lang.String value,
                 org.apache.poi.xssf.usermodel.XSSFComment comment)

Specified by:

cell in interface org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler

cell

public void cell(short columnIndex,
                 java.lang.String value,
                 org.apache.poi.ss.usermodel.Comment comment)

cell 정보 parsing

Parameters:

columnIndex - 컬럼 index

value - value

comment - comment

getRows

public java.util.List<UstraExcelUtils.RowInfo> getRows()

row 목록

getClazz

public java.lang.Class<?> getClazz()

클래스 목록

isStopOnError

public boolean isStopOnError()

오류 시 중지 여부

getHeaderRowIndex

public int getHeaderRowIndex()

헤더 정보 추출을 위한 index