jxls报表生成利器，比起jxl，poi牛逼得很

最新推荐文章于 2025-09-22 10:38:14 发布

原创最新推荐文章于 2025-09-22 10:38:14 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #人工智能 #python

报表工具专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个使用jXls库实现的Java程序案例，该程序从模板文件读取数据并填充到Excel文件中。示例展示了如何定义部门、员工及主管等对象，并将这些对象的数据写入Excel文件的具体过程。

参考文章

[url]https://wenku.baidu.com/view/4126bc8071fe910ef12df854.html[/url]

[url]http://blog.sina.com.cn/s/blog_4d6be6f30101fd67.html[/url]

[url]https://www.yangqiu.cn/xwzhongchou/1441843.html[/url]

[url]http://blog.youkuaiyun.com/memoryzxj/article/details/50801454[/url]

实例代码


package com.test;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import net.sf.jxls.exception.ParsePropertyException;
import net.sf.jxls.transformer.XLSTransformer;

public class TestJxlsExportReport {

	public static void main(String[] args) throws ParsePropertyException, InvalidFormatException, IOException {
		// TODO Auto-generated method stub

		String templateFileName = "D:\\excel\\temp.xls";
		String destFileName = "D:\\excel\\out.xls";

		File file = new File(destFileName);
		if(file.exists())
		file.delete();


		List<Department> departments = ddd();

		Map<String,List<Department>> beans

		= new HashMap<String,List<Department>>();

		beans.put("departments", departments);

		XLSTransformer transformer = new XLSTransformer();

		transformer.transformXLS(templateFileName, beans,destFileName);
	}

	public static List<Department> ddd(){
		List<Department> dlist = new ArrayList<Department>();

		Department ds = new Department();
		ds.setName("人力资源部");
		ds.setDesc("XXX");
		ds.setData1(1);
		ds.setData2(8);
		dlist.add(ds);

		Chief cf = new Chief();
		cf.setName("张三");
		cf.setAge(18);
		cf.setPayment("1");
		cf.setBonus("2");
		ds.chief.add(cf);

		cf = new Chief();
		cf.setName("李四");
		cf.setAge(20);
		cf.setPayment("3");
		cf.setBonus("4");
		ds.chief.add(cf);

		Employee e = new Employee();
		e.setName("王五");
		e.setAge(30);
		e.setBonus(30.25f);
		e.setPayment(63.66f);
		ds.staff.add(e);

		e = new Employee();
		e.setName("Tom");
		e.setAge(4);
		e.setBonus(10.25f);
		e.setPayment(23.66f);
		ds.staff.add(e);


		ds = new Department();
		ds.setName("行政部");
		ds.setDesc("yyyy");
		ds.setData1(7);
		ds.setData2(9);
		dlist.add(ds);




		cf = new Chief();
		cf.setName("张三");
		cf.setAge(18);
		cf.setPayment("1");
		cf.setBonus("2");
		ds.chief.add(cf);

		cf = new Chief();
		cf.setName("李四");
		cf.setAge(20);
		cf.setPayment("3");
		cf.setBonus("4");
		ds.chief.add(cf);

		e = new Employee();
		e.setName("王五");
		e.setAge(30);
		e.setBonus(30.25f);
		e.setPayment(63.66f);
		ds.staff.add(e);

		e = new Employee();
		e.setName("Tom");
		e.setAge(4);
		e.setBonus(10.25f);
		e.setPayment(23.66f);
		ds.staff.add(e);






		return dlist;
	}

}