tang_zongyun 2023-05-22 16:51:25 博主文章分类：报表工具 ©著作权
文章标签 java 人工智能 python List html 文章分类 代码人生
©著作权归作者所有：来自51CTO博客作者tang_zongyun的原创作品，请联系作者获取转载授权，否则将追究法律责任参考文章
[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]
实例代码
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 stubString templateFileName = "D:\excel\temp.xls";String destFileName = "D:\excel\out.xls";File file = new File(destFileName);if(file.exists())file.delete();List departments = ddd();Map beans= new HashMap();beans.put("departments", departments);XLSTransformer transformer = new XLSTransformer();transformer.transformXLS(templateFileName, beans,destFileName);}public static List ddd(){List dlist = new ArrayList();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;}} 赞 收藏 评论 分享 举报