JAVA 操作 EXCEL 模板生成 EXCEL 方法:
可以和 JSTL 一样用,方便,快捷,简单]
(1)引入 JAR 包如下:
(2)EXCEL 模板如下:
(3)JAVA 代码如下:
List staff = new ArrayList();
staff.add(new Employee("Derek", 35, 3000, 0.30));
staff.add(new Employee("Elsa", 28, 1500, 0.15));
staff.add(new Employee("Oleg", 32, 2300, 0.25));
staff.add(new Employee("Neil", 34, 2500, 0.00));
staff.add(new Employee("Maria", 34, 1700, 0.15));
staff.add(new Employee("John", 35, 2800, 0.20));
staff.add(new Employee("Leonid", 29, 1700, 0.20));
Map beans = new HashMap();
beans.put("employee", staff);
XLSTransformer transformer = new XLSTransformer();
String templateFileName="templateFile.xls";
String destFileName="outFile.xls";
try {
transformer.transformXLS(templateFileName, beans, destFileName);
} catch (ParsePropertyException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
(4)生成的 EXCEL 如下: