Boost Java Excel Import/Export Performance with AlanPOI – A Quick Guide

Feature Overview

IMPORT

ExcelHandle core processor

ExcelWorkbookManage for managing all worksheets

ExcelInitConfig for configuration file initialization

AbstractFileParser for file conversion

Why choose AlanPOI import?

No need to manually add POI jars

Millisecond-level parsing of large files, one‑click multi‑sheet import without manual loops

Supports any number of imports and returns accurate objects, reducing developer effort

Provides error feedback per row, writing errors back to Excel

Extensible via ExcelConsumeInterface with valid, error, end callbacks

How to use AlanPOI for import

Create excel-config.xml under resources, define consume class, sheet VO, and column mappings. Example:

<?xml version="1.0" encoding="GB2312"?>
<exg name="excelId" version="1.0" file-type="excel">
  <excel id="ACCOUNT" consume="com.xxx.FinAccountImportHandler">
    <sheet index="0" row-start="1" column-start="0" vo="com.xxx.vo.FinAccountImportVO">
      <column name="公司/供应商编号" offset="1">companyCode</column>
      <column name="公司/供应商名称" offset="2">companyName</column>
      <column name="银行账号" offset="3">bankAccount</column>
      <column name="开户银行" offset="4">bankName</column>
    </sheet>
  </excel>
</exg>

Implementing the consumer

Implement ExcelConsumeInterface with three methods:

void error(ExcelError excelError);
void validData(String workbookId, List<ExcelSheetData> sheetDataList, Map<Serializable, Object> excelParam);
void end(List<ExcelSheetData> sheetDataList, Map<Serializable, Object> excelParam);

Export functionality

One‑line export via ExcelExportUtil.export(...) or obtain a Workbook with ExcelExportUtil.getWorkbook(...). Supports annotation‑driven column definitions such as @ExcelSheet, @ExcelColumn, @DateFormat, @NumFormat.

Advanced usage examples

Dynamic column export, multi‑sheet export, and custom workbook handling are demonstrated with sample code snippets.

https://github.com/alan-et/alanpoi/tree/develop/alanpoi-analysis