Home

ExcelUtil is a wrapper library of Apache POI for reading and writing Excel in declarative fashion.

This documentation provides fully in-depth guides and sample use-cases where this library can make your life easier when it comes to handling Excel.

Installation

ExcelUtil is using Apache POI 5.2.5 internally.

<dependency>
    <groupId>io.github.nambach</groupId>
    <artifactId>ExcelUtil</artifactId>
    <version>2.5.1</version>
</dependency>

User Guides

1. Write Excel

• Write DTO list
• Create custom template
• Work with Excel 97-2003
• Other things

2. Read Excel

• Read DTO list
• Validation

3. Best Practices

• Read and write using Editor
• Classes cheatsheet
• Working with Style

Notes

• Minimum version: JDK 8
• Support Excel version: 97-2003 (.xls), 2007+ (.xlsx)

Questions and supports

If you spot a bug or request a new feature, please raise an issue.