根据模板导出excel java编写
根据excel模版导出excel，核心代码如下：
/*-------------- 1.准备数据--------------*/
List<Object> resultList = new ArrayList<Object>();
Date todays = new Date();//日期
List<Object> countList = new ArrayList<Object>();//行数据
countList.add("A-001");//类别
countList.add(20L);//数量
resultList.add(countList);
countList = new ArrayList<Object>();//行数据
countList.add("A-002");//类别
countList.add(24L);//数量
resultList.add(countList);
int counts = 60;
ExcelUtils.addValue("typename","运输类");
ExcelUtils.addValue("counts",counts);
ExcelUtils.addValue("todays",todays);
ExcelUtils.addValue("resultList", resultList);
/*-------------- 2.写出excel文件--------------*/
String dirs = this.getProjectDirs() + "template/";
String templateFileName = "AircraftType";//模版名称（不含扩张名） AircraftType
String templateFilePath = dirs + templateFileName + ".xls";
String destFilePath = dirs + templateFileName + "-out.xls";
try {
System.out.println("templateFilePath="+templateFilePath);
OutputStream out = new FileOutputStream(destFilePath);
ExcelUtils.export(templateFilePath, out);
System.out.println("destFilePath="+destFilePath);
} catch (ExcelException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
}
文件下载
资源详情
[{"title":"（ 27 个子文件 2.41MB ） 根据模板导出excel java编写","children":[{"title":"excel","children":[{"title":".settings","children":[{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'> 6B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.project.facet.core.xml <span style='color:#111;'> 252B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'> 532B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'> 500B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 395B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"hangyun","children":[{"title":"excel","children":[{"title":"ExcelExportDemo.java <span style='color:#111;'> 2.34KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".project <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":"WebRoot","children":[{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 36B </span>","children":null,"spread":false}],"spread":true},{"title":"WEB-INF","children":[{"title":"web.xml <span style='color:#111;'> 404B </span>","children":null,"spread":false},{"title":"classes","children":[{"title":"com","children":[{"title":"hangyun","children":[{"title":"excel","children":[{"title":"ExcelExportDemo.class <span style='color:#111;'> 2.97KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"template","children":[{"title":"AircraftType-out.xls <span style='color:#111;'> 14.50KB </span>","children":null,"spread":false},{"title":"AircraftType.xls <span style='color:#111;'> 14.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"lib","children":[{"title":"commons-collections-3.0.jar <span style='color:#111;'> 506.49KB </span>","children":null,"spread":false},{"title":"commons-logging-1.0.4.jar <span style='color:#111;'> 37.12KB </span>","children":null,"spread":false},{"title":"poi-contrib-3.0.1.jar <span style='color:#111;'> 57.96KB </span>","children":null,"spread":false},{"title":"commons-beanutils.jar <span style='color:#111;'> 184.25KB </span>","children":null,"spread":false},{"title":"poi-3.0.1.jar <span style='color:#111;'> 887.96KB </span>","children":null,"spread":false},{"title":"excelutils.jar <span style='color:#111;'> 34.83KB </span>","children":null,"spread":false},{"title":"commons-io-1.1.jar <span style='color:#111;'> 60.12KB </span>","children":null,"spread":false},{"title":"commons-lang-2.0.jar <span style='color:#111;'> 165.78KB </span>","children":null,"spread":false},{"title":"poi-scratchpad-3.0.1.jar <span style='color:#111;'> 839.47KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"index.jsp <span style='color:#111;'> 834B </span>","children":null,"spread":false}],"spread":true},{"title":"resource","children":[{"title":"template","children":[{"title":"AircraftType-out.xls <span style='color:#111;'> 14.50KB </span>","children":null,"spread":false},{"title":"AircraftType.xls <span style='color:#111;'> 14.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".mymetadata <span style='color:#111;'> 288B </span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'> 576B </span>","children":null,"spread":false},{"title":".myeclipse","children":null,"spread":false}],"spread":true}],"spread":true}]
评论信息
-
-
-
从不扯犊子的杨小六 :到还是可以吧。只能借鉴下而已2015-10-24 -
-
飞机在哪 :还可以，功能可以实现2015-08-12
-
-
么么2014 :被坑了 白瞎我的积分了 一点都不好2015-06-15
-
-
shanxiufang :很有用，谢谢了2015-06-05
-
-
兔兔妞 :还可以,还是比较实用的2014-07-30
-
其他资源
- 武汉理工大学计算机马区综合实验3（数据结构综合实验）
- 射频电路理论与设计
- ICEM视频教程
- BP算法实现26个字母识别
- centos7.9.2009.zip
- 《应用数理统计》课后习题答案
- 全自动电脑打铃器中北大学硬件大型实验单片机课程设计
- Unity相机镜头特效包
- 基于粒子群算法的图像聚类算法
- 数据分析实战一数据.csv
- VAD函数调用关系(done).vsdx
- 9玩转手机摄影的光影 艺术.pdf
- 最新微信域名检测防封API接口大全（多语言版）
- esxi网卡聚合负载均衡
- BJUT数字图像处理作业
- C# FTP操作帮助类, FTPHelper.cs
- 图像抖动的块匹配及补偿算法
- Control4驱动的编写
- poi-3.17开发用所有jar包
- sift算法生成全景图（matlab）
- dom4j-1.6.1.jar下载
- 淘宝客小程序源码
- DPS安装程序
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明