📑
Allbs Excel
Spring Boot Excel Import/Export Enhancement Tool
Overview
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.
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
Tech Stack
Spring Boot EasyExcel Java 17+
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
🧪
Web App 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.
java spring-boot excel