2022-10-10-TIL

Today I Learned

Apache POI

  • https://deepakschoudhary.medium.com/how-i-escaped-apache-poi-and-found-my-dream-3rd-party-excel-writer-5e56dd73e407
  • https://blog.naver.com/PostView.naver?blogId=stylehosting&logNo=221962575020&categoryNo=7&parentCategoryNo=0&viewDate=&currentPage=1&postListTopCurrentPage=1&from=postView
  • https://blog.naver.com/PostView.nhn?blogId=sence255&logNo=222374664383&parentCategoryNo=15&categoryNo=&viewDate=&isShowPopularPosts=false&from=postView
  • https://velog.io/@codesweaver/Spring4-%EC%97%91%EC%85%80-%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C-%EC%86%8D%EB%8F%84-64%EB%B0%B0-%EA%B0%9C%EC%84%A0%ED%95%9C-%EC%9D%B4%EC%95%BC%EA%B8%B0-0pb9j1h4
  • https://velog.io/@codesweaver/Spring4-%EC%97%91%EC%85%80-%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C-%EC%86%8D%EB%8F%84-64%EB%B0%B0-%EA%B0%9C%EC%84%A0%ED%95%9C-%EC%9D%B4%EC%95%BC%EA%B8%B0-0pb9j1h4
  • https://andriymz.github.io/misc/apache-poi-slow-excel-generation/#
  • https://levelup.gitconnected.com/how-to-write-a-million-rows-in-an-excel-file-efficiently-5f7ce6c69314
  • https://gist.github.com/kawasima/f33ab14000ba14b7dada
  • https://javadoc.io/static/org.apache.poi/poi-ooxml/4.1.1/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
  • https://stackoverflow.com/questions/33786219/apache-poi-streaming-sxssf-for-reading
  • https://poi.apache.org/components/spreadsheet/how-to.html
  • https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
  • https://poi.apache.org/components/spreadsheet/limitations.html
  • https://www.programcreek.com/java-api-examples/?api=org.apache.poi.xssf.streaming.SXSSFWorkbook
  • https://www.digitalocean.com/community/tutorials/apache-poi-tutorial
  • https://howtodoinjava.com/java/library/readingwriting-excel-files-in-java-poi-tutorial/
  • https://github.com/T5750/poi
  • https://blog.simplicityweb.co.uk/120/generating-large-spreadsheets-more-efficiently-using-sxssf
  • https://blog.naver.com/hj_kim97/222374962489

How to use POI SXSSF to read large spreadsheet

  • https://stackoverflow.com/questions/10053421/how-to-use-poi-sxssf-to-read-a-large-spreadsheet
  • https://okky.kr/articles/348270
  • https://roytuts.com/how-to-read-large-excel-file-using-apache-poi/
  • https://stackoverflow.com/questions/42380765/read-huge-excel-file500k-rows-in-java
  • https://poi.apache.org/components/spreadsheet/how-to.html#xssf_sax_api
  • https://github.com/monitorjbl/excel-streaming-reader

JXL vs Apache POI

  • https://stackoverflow.com/questions/14980717/what-is-the-better-api-to-reading-excel-sheets-in-java-jxl-or-apache-poi