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

Class UstraExcelCellGenerator

java.lang.Object
com.gsitm.ustra.java.data.poi.generator.UstraExcelCellGenerator
Direct Known Subclasses:
SimpleUstraExcelCellGenerator
public abstract class UstraExcelCellGenerator extends Object
데이터를 엑셀 셀로 변환하는 generator

  • Constructor Summary

    Constructors
    Constructor
    Description
    UstraExcelCellGenerator()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    protected void
    addCellStyle(String key, org.apache.poi.ss.usermodel.CellStyle value)
    cell style을 추가
    void
    addCurrentRow()
    현재 row 값을 증가
    protected org.apache.poi.xssf.streaming.SXSSFRow
    createRow(org.apache.poi.xssf.streaming.SXSSFSheet sheet)
    sheet에 row를 신규 생성
    abstract void
    customizeSheet(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
    cell 생성 완료 후, workbook / sheet customize
    protected List<Map<String,Object>>
    getBodyData(UstraExcelModel model, int index)
    Body에 바인딩할 데이터를 조회한다.
    protected org.apache.poi.ss.usermodel.CellStyle
    getCellStyle(String key)
    cell style 조회
    Map<String,org.apache.poi.ss.usermodel.CellStyle>
    getCellStyleMap()
     
    int
    getCurrentRow()
     
    abstract void
    init(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet)
    초기화 수행
    abstract void
    makeBody(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
    Body 생성
    abstract void
    makeFooter(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
    Footer 생성
    abstract void
    makeHeader(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
    헤더 생성
    abstract void
    makeTitle(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
    타이틀 영역 생성

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • UstraExcelCellGenerator

      public UstraExcelCellGenerator()

  • Method Details

    • addCellStyle

      protected void addCellStyle(String key, org.apache.poi.ss.usermodel.CellStyle value)
      cell style을 추가
      Parameters:
      key - key 값
      value - cellStyle

    • getCellStyle

      protected org.apache.poi.ss.usermodel.CellStyle getCellStyle(String key)
      cell style 조회
      Parameters:
      key - 키 값

    • init

      public abstract void init(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet)
      초기화 수행

    • makeTitle

      public abstract void makeTitle(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
      타이틀 영역 생성
      Parameters:
      workbook - 워크북
      sheet - Sheet
      model - UstraExcelModel

    • makeHeader

      public abstract void makeHeader(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
      헤더 생성
      Parameters:
      workbook - 워크북
      sheet - Sheet
      model - UstraExcelModel

    • makeBody

      public abstract void makeBody(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
      Body 생성
      Parameters:
      workbook - 워크북
      sheet - Sheet
      model - UstraExcelModel

    • getBodyData

      protected List<Map<String,Object>> getBodyData(UstraExcelModel model, int index)
      Body에 바인딩할 데이터를 조회한다. UstraExcelWorksheetDataProvider 옵션 추가로 body data 조회 처리 추가
      Parameters:
      model - UstraExcelModel
      index - 조회 순번

    • makeFooter

      public abstract void makeFooter(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
      Footer 생성
      Parameters:
      workbook - 워크북
      sheet - Sheet
      model - UstraExcelModel

    • customizeSheet

      public abstract void customizeSheet(org.apache.poi.xssf.streaming.SXSSFWorkbook workbook, org.apache.poi.xssf.streaming.SXSSFSheet sheet, UstraExcelModel model)
      cell 생성 완료 후, workbook / sheet customize
      Parameters:
      workbook - 워크북
      sheet - Sheet

    • createRow

      protected org.apache.poi.xssf.streaming.SXSSFRow createRow(org.apache.poi.xssf.streaming.SXSSFSheet sheet)
      sheet에 row를 신규 생성
      Parameters:
      sheet - sheet
      Returns:
      엑셀 Row

    • addCurrentRow

      public void addCurrentRow()
      현재 row 값을 증가

    • getCellStyleMap

      public Map<String,org.apache.poi.ss.usermodel.CellStyle> getCellStyleMap()

    • getCurrentRow

      public int getCurrentRow()