alanpoi: A Java Library for Efficient Excel Import and Export

alanpoi is a Java library that simplifies Excel import and export without requiring additional POI jars, offering millisecond‑level parsing of large files, multi‑sheet support, error feedback, and extensible consumption interfaces.

Import features include core processors such as ExcelHandle , workbook management ExcelWorkbookManage , configuration initialization ExcelInitConfig , and file conversion AbstractFileParser . Users configure excel-config.xml to map sheets and columns to VO classes, then implement ExcelConsumeInterface with valid , error , and end methods.

Typical usage adds the Maven dependency:

<code>&lt;dependency&gt;
    &lt;groupId&gt;com.alanpoi&lt;/groupId&gt;
    &lt;artifactId&gt;alanpoi-analysis&lt;/artifactId&gt;
    &lt;version&gt;1.3.0&lt;/version&gt;
&lt;/dependency&gt;
</code>

After configuration, the import is triggered via ExcelExportUtil.customImportData with the Excel ID defined in the XML.

Export features provide annotation‑driven sheet and column definitions ( @ExcelSheet , @ExcelColumn , @DateFormat , @NumFormat ) and can generate workbooks with a single call such as ExcelExportUtil.export(...) or ExcelExportUtil.getWorkbook(...) . Advanced usage includes selective column export and multi‑sheet export, demonstrated with Java code snippets.

Overall, alanpoi reduces boilerplate, improves performance, and offers flexible, extensible Excel handling for backend Java applications.