2022-10-24-TIL

Today I Learned

Apache POI HSSF vs XSSF vs SXSSF

HSSF는 xls만 사용가능하므로 제외하고, XSSF와 SXSSF 중에서는 메모리에 모두 올려놓지 않고 사용하는 SXSSF가 유리

  • https://www.tutorialspoint.com/apache_poi/apache_poi_quick_guide.htm
  • https://stackoverflow.com/questions/45936257/apache-poi-hssf-vs-poi-xssf
  • https://erictus.tistory.com/entry/POI-HSSF-XSSF-SXSSF-%EC%84%B1%EB%8A%A5-%EB%B6%84%EC%84%9D
  • https://stackoverflow.com/questions/33047512/hssfworkbook-vs-xssfworkbook-vs-sxssfworkbook-apache-poi
  • https://poi.apache.org/components/spreadsheet/
  • https://poi.apache.org/components/spreadsheet/how-to.html#user_api
  • https://www.adoclib.com/blog/hssfworkbook-vs-xssfworkbook-vs-sxssfworkbook-apache-poi.html
  • https://j-dev.tistory.com/entry/SpringPOI-%EB%8C%80%EC%9A%A9%EB%9F%89-%EC%97%91%EC%85%80-%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C
  • https://topic.alibabacloud.com/a/the-difference-between-hssfxssf-and-sxssf_8_8_31570522.html
  • https://okky.kr/articles/408564
  • https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
  • http://www.java2s.com/example/java-api/org/apache/poi/xssf/streaming/sxssfworkbook/sxssfworkbook-4-0.html
  • https://qiita.com/tool-taro/items/4b3c802bb114a9110ecb

Apache POI vs Fastexcel

  • https://automationqahub.com/top-2-alternatives-to-apache-poi-library-that-can-actually-make-your-life-better/
  • https://www.libhunt.com/compare-fastexcel-vs-poi
  • https://github.com/dhatim/fastexcel
  • https://www.baeldung.com/java-microsoft-excel
  • https://zetcode.com/java/fastexcel/