자기개발

Poi Library

집테크 2022. 7. 5. 01:21

http://poi.apache.org/download.html

 

Apache POI - Download Release Artifacts

<!--+ |breadtrail +--> <!--+ |start Menu, mainarea +--> <!--+ |start Menu +--> <!--+ |end Menu +--> <!--+ |start content +--> Apache POI - Download Release Artifacts Available Downloads This page provides instructions on how to download and verify the Apac

poi.apache.org

xls형식

  • Microsoft Excel 97-2003 버전 사용
  • 최대 256 컬럼, 65,536행 제한
  • org.apache.poi.hssf 패키지 활용
    • org.apache.poi.hssf.usermodel.HSSFWorkbook
    • org.apache.poi.hssf.usermodel.HSSFSheet
    • org.apache.poi.hssf.usermodel.HSSFRow
    • org.apache.poi.hssf.usermodel.HSSFCell

xlsx형식

  • Microsoft Excel 2007 이후 버전에서 사용
  • 최대 16,384컬럼, 1,048,567행 제한
  • org.apache.poi.xssf 패키지 활용
    • org.apache.poi.xssf.usermodel.XSSFWorkbook
    • org.apache.poi.xssf.usermodel.XSSFSheet
    • org.apache.poi.xssf.usermodel.XSSFRow
    • org.apache.poi.xssf.usermodel.XSSFCell