基于POI的配置式热加载Excel导出工具

POI Based Configurable Hot-Loaded Tool for Excel Export

在项目开发中Excel导出是一个常见的需求,该文对常见的Excel需求进行分析,设计了一套配置属性定义Excel导出内容及样式,通过解析配置文件,来确定Excel的内容和样式,并基于POI封装实现了一个Excel导出工具。一方面极大地降低了学习成本及开发维护成本;另一方面在服务运行过程中无需停机,直接修改配置文件即可响应导出需求变动。

Excel export is a common requirement in project.This paper analyzes the common excel export requirements,designs a set of configuration attributes to define the excel content and style.The excel content and style are determined by analyzing the configuration file.Also implemented an excel export tool based on POI.On the one hand,it greatly reduces the learning cost and development and maintenance cost;On the other hand,there is no need to shut down service during running time.Just modify the configuration file to respond to changes in export requirements directly.