基于Java反射和Fel计算引擎动态导出Excel的实现

Implementation of Dynamic Excel Export Based on Java Reflection and Fel Computing Engine

本文提出一种Excel导出方式,通过自定义类注解和方法注解,配置Fel表达式,实现Excel灵活动态的导出功能,并且同时支持方法导出、SQL导出、直接导出三种导出方式,而且无需更改或添加新的代码,大大减少了程序员的工作量,提高了复用性。

This paper proposes an Excel export method,which realizes the flexible and dynamic export function of Excel by configuring FEL expression through user-defined class annotation and method annotation.At the same time,it supports three ex⁃port methods:Method export,SQL export and direct export,and there is no need to change or add new code,which greatly reduces the workload of programmers and improves the reusability.