MyExcel multifunctional Excel toolkit v3.12.0

MyExcel is a toolkit that integrates multiple functions such as importing, exporting, and encrypting Excel.

advantage

Can generate tables of any complexity: This tool uses iterative cell methods for excel drawing, can generate excel of any complexity, and has adaptive width and height;

Zero learning cost: using HTML as a template, the learning cost is almost zero;

Supports commonly used background colors, borders, fonts and other style settings: see the Documentation - Style Support section for details;

Supports .xls, .xlsx, and .csv: Supports generating Excel and .csv files with .xls and .xlsx suffixes;

Supports formula export: supports setting formulas in Excel templates to reduce the calculation amount on the server side;

Support low-memory SXSSF mode: Support low-memory SXSSF mode, which can use extremely low memory to generate .xlsx;

Supports producer-consumer mode export: Supports producer-consumer mode export, without the need to obtain all data at once, and obtains data in batches with the SXSSF mode to achieve truly massive data export;

Supports multiple template engines: Excel builders for commonly used template engines such as Freemarker, Groovy, Beetl, and Thymeleaf have been built in (see the document Getting started for details). It is recommended to use the Beetl template engine (Beetl document);

Provides a default Excel builder to directly output simple Excel: no need to write any HTML, the default template has been built in, and can be output directly based on the POJO data list;

Supports generating multiple sheets at one time: using table as sheet unit, supports exporting multiple sheets in one excel document;

Supports Excel capacity setting: Supports setting Excel capacity. Once the capacity is reached, Excel will be automatically created and can be constructed into a zip package and exported;