POI at 20
summary
Apache POI celebrates twenty years as a Java API for Microsoft Office formats, supporting old binary (.doc/.xls) and OOXML (.docx/.xlsx) formats with 250,000 lines of code and about 24 PMC members. It uses an xmlbeans-based OOXML model for modern files, adds streaming to avoid DOM memory blowups, integrates with Apache Tika for extraction, writes rich Excel features (dropdowns, locked regions, macros copied between workbooks), and notes gaps: deep sheet copying and centralized style management. Version 5.0 ships Java 9 module support; minimum Java 8.
AI-written summary · about
chapters (24)
- 0:00Introduction to POI at 20
- 1:54What Apache POI does
- 3:16History and timeline of POI
- 5:28What you can do with POI
- 9:22POI versus alternatives
- 11:29Reverse engineering Office formats
- 13:55Modern formats and standards
- 14:35Java versions and POI
- 16:00POI module structure
- 17:47Best practices for POI usage
- 18:09How to get POI
- 19:55POI release cycle
- 20:36XMLBeans and subprojects
- 22:01Areas for POI improvement
- 23:04Contributing to POI
- 24:50Bug compatibility with Office
- 25:31Memory usage with XML formats
- 26:54Streaming XML processing
- 27:56Standards and Office behavior
- 28:58Excel rounding and precision
- 29:44Working with macros
- 30:45Future of POI
- 31:48Community and evolution
- 33:11Q&A
