The well-known frameworks for Java analysis and Excel generation are Apache poi and jxl. But they all have a serious problem that is very memory-consuming. Poi has a set of SAX-mode APIs that can solve some memory overflow problems to a certain extent, but POI still has some defects, such as the 07 version of Excel decompression and storage after decompression. It is done in memory, and the memory consumption is still large. easyexcel rewrote poi's analysis of version 07 of Excel. The original 3M excel using POI sax still needs about 100M to reduce the memory to a few M, and no memory overflow occurs in the larger excel. The 03 version relies on the sax mode of POI. The model conversion is encapsulated in the upper layer, which makes it easier and more convenient for users.
