sitelink1 http://poi.apache.org/spreadsheet/index.html 
sitelink2  
sitelink3  
extra_vars4  
extra_vars5  
extra_vars6  

HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

HSSF and XSSF provides ways to read spreadsheets create, modify, read and write XLS spreadsheets. They provide:

  • low level structures for those with special needs
  • an eventmodel api for efficient read-only access
  • a full usermodel api for creating, reading and modifying XLS files

For people converting from pure HSSF usermodel, who wish to use the joint SS Usermodel for HSSF and XSSF support, then see the ss usermodel converting guide.

An alternate way of generating a spreadsheet is via the Cocoon serializer (yet you'll still be using HSSF indirectly). With Cocoon you can serialize any XML datasource (which might be a ESQL page outputting in SQL for instance) by simply applying the stylesheet and designating the serializer.

If you're merely reading spreadsheet data, then use the eventmodel api in either the org.apache.poi.hssf.eventusermodel package, or the org.apache.poi.xssf.eventusermodel package, depending on your file format.

If you're modifying spreadsheet data then use the usermodel api. You can also generate spreadsheets this way.

Note that the usermodel system has a higher memory footprint than the low level eventusermodel, but have the major advantage of being much simpler to work with. Also please be aware that as the new XSSF supported Excel 2007 OOXML (.xlsx) files are XML based, the memory footprint for processing them is higher than for the older HSSF supported (.xls) binary files.

번호 제목 글쓴이 날짜 조회 수
58 셀 크기 조정 (자동 크기 조정) 황제낙엽 2011.05.03 7817
57 Cell 의 wrap 설정 (텍스트 개행) file 황제낙엽 2011.05.09 3125
56 병합된 셀의 스타일( border) 설정하기 황제낙엽 2011.05.03 1761
55 POI HSSF, XSSF, SXSSF 성능 분석 file 황제낙엽 2013.11.05 1663
54 Parsing and Processing Large XML Documents with Digester Rules (해석중) file 황제낙엽 2008.05.13 1571
53 POI 셀 스타일 설정을 위한 예제 소스 file 황제낙엽 2008.05.16 1464
52 엑셀(Excel)문서 처리 패키지 황제낙엽 2007.01.22 1452
» POI-HSSF and POI-XSSF - Java API To Access Microsoft Excel Format Files 황제낙엽 2013.11.05 1135
50 Comma Separated Values (CSV) - au.com.bytecode.opencsv file 황제낙엽 2007.01.23 901
49 Parsing, indexing, and searching XML with Digester and Lucene 황제낙엽 2008.05.07 546
48 Library & Properties 파일 file 황제낙엽 2011.12.23 496
47 POI HSSF 기능 가이드 -- 퀵·가이드 (한글) 황제낙엽 2008.05.16 436
46 JUnit 3.8에서 JUnit 4, TestNG 활용으로 황제낙엽 2007.09.17 426
45 Junit 을 이용한 효율적인 단위 테스트 전략 황제낙엽 2007.01.30 371
44 XSSF Examples file 황제낙엽 2011.05.04 337
43 POI HSSF 기능 가이드 -- 퀵·가이드 (영문) 황제낙엽 2008.05.15 304
42 사용자 정의 Appender 정의하여 Log4j 확장하기 황제낙엽 2009.05.28 291
41 log4j-1.2.15.jar 와 log4j.properties 예제 file 황제낙엽 2017.08.04 283
40 Apache Log4j 2 Configuration 파일 설정 황제낙엽 2020.04.01 276
39 Comma Separated Values (CSV) - com.Ostermiller.util Java Utilities 황제낙엽 2007.01.23 272