Library
Allbs Excel
Spring Boot Excel Import/Export Enhancement Tool
An enhanced Excel import/export tool for Spring Boot based on EasyExcel. Implement Excel import/export functionality through annotations, supporting advanced features such as data validation, dictionary conversion, data masking, etc.
Tech Stack: Spring BootEasyExcelJava 17+
Screenshots
Features
Annotation-driven import/export
Single/Multiple sheet support
Template export functionality
Data validation and masking
Dictionary conversion
Internationalized header support
Nested object export/import
Conditional styling and dynamic headers
Formulas, freeze panes, conditional formatting
Comments, images, encryption, watermarks
Progress callback monitoring
Installation
Maven Dependency:
```xml
<dependency>
<groupId>cn.allbs</groupId>
<artifactId>allbs-excel</artifactId>
<version>3.0.0</version>
</dependency>
```
Basic Usage:
1. Add @ExcelProperty annotation to entity class fields
2. Add @ExportExcel annotation to Controller methods for export
3. Add @ImportExcel annotation to Controller parameters for import Related Tools
Allbs Excel Test Tool
Allbs Excel Feature Demo and Test Platform
A companion test and demo tool for Allbs Excel, providing comprehensive feature demonstrations and an online testing environment to help developers quickly understand and experience the various features of Allbs Excel.
Spring Boot Allbs Excel Vue.js Element UI
Complete feature demonstration cases
Online testing environment
Import/export examples
+3 more