Package 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 Object implements org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler
Excel Parsing 처리

  • Constructor Details

    • UstraExcelParser

      public UstraExcelParser()

  • Method Details

    • initialize

      public void initialize(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(String text, boolean isHeader, 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 Object parseRowAsEntity(int rowNum)
      row를 entity로 parsing
      Parameters:
      rowNum - row 번호
      Returns:
      entity instance

    • parseRowAsMap

      protected Map<String,Object> parseRowAsMap(int rowNum)
      row를 map으로 parsing
      Parameters:
      rowNum - row 번호
      Returns:
      map instance

    • createDecoder

      protected UstraExcelCellDecoder createDecoder(String decoderClassName)
      decoder 인스턴스 생성
      Parameters:
      decoderClassName -
      Returns:

    • cell

      public void cell(String columnName, 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, String value, org.apache.poi.ss.usermodel.Comment comment)
      cell 정보 parsing
      Parameters:
      columnIndex - 컬럼 index
      value - value
      comment - comment

    • getRows

      public List<UstraExcelUtils.RowInfo> getRows()
      row 목록

    • getClazz

      public Class<?> getClazz()
      클래스 목록

    • isStopOnError

      public boolean isStopOnError()
      오류 시 중지 여부

    • getHeaderRowIndex

      public int getHeaderRowIndex()
      헤더 정보 추출을 위한 index