A POI introductionApache POI is an open source library of the Apache Software Foundation, where POI provides APIs to Java programs for Microsoft Office format Archives Read and write functions. Since 2009-09-28, the release of the 3.5 version, providing support for Office2007;
POI supports Excel, Word, and more in the Official Documents section: Click to open the link
two basic definitions of something no need to write a
2.1 POI Primer: Click to open link
2.2 poi3.8 Component Research 1-9 series: click Open link recommended
2.3 poi to clarify the relationship between components (HSSF,xssf,poifs) and patterns see: Why translate to components from Wikipedia: The Apache POI project Contains the following subcomponents (I translated "components" meaning of acronyms is taken from old documentation): HSSF,xssf,poifs, etc. click to open the link
The following articles describe the Excel million data import (to database) export.
My blog All articles directory: Click to open the link
One of the Apache POI series Tutorials: Poi Getting Started tutorial