利用JXLS根据模板导出Excel实例教程

本文主要是介绍利用JXLS根据模板导出Excel实例教程，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

看了几天了，感觉迷迷糊糊的，今天终于搞出来了。

先做模板，做成想要的格式样子保存，然后通过程序根据模板生成对应样式的Excel文件，代码简单。什么连接数据库查询然后将结果生成Excel文件就不讲了，放入List里面，然后套一下就行了，照老虎花猫。

准备：

1，相关jar包：

2，模板文件：

开始，

1、先实体类：Staff.java

package myjxls;
/*** 2014-3-17* 8dou* 实体*/
public class Staff {/*** 名称*/private String name;/*** 薪资*/private Double payment;/*** 年终奖*/private Double bonus;public String getName() {return name;}public void setName(String name) {this.name = name;}public Double getPayment() {return payment;}public void setPayment(Double payment) {this.payment = payment;}public Double getBonus() {return bonus;}public void setBonus(Double bonus) {this.bonus = bonus;}public Staff(String name, Double payment, Double bonus) {super();this.name = name;this.payment = payment;this.bonus = bonus;}
}

2、测试类 ChartTest.java

package myjxls;
/*** 2014-3-17* 8dou* 测试JXLS根据模板样式导出Excel*/
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import net.sf.jxls.transformer.XLSTransformer;
public class ChartTest {/*** @param args*/public static void main(String[] args) throws Exception {List<Staff> staffs = new ArrayList<Staff>();Staff s1 = new Staff("张三", 6000D, 3000D);staffs.add(s1);Staff s2 = new Staff("李四", 5000D, 2000D);staffs.add(s2);Staff s3 = new Staff("王五", 4000D, 1000D);staffs.add(s3);String srcFilePath = "e:/simple.xlsx";String destFilePath = "e:/template-simple.xlsx";Map<String, List<Staff>> beanParams = new HashMap<String, List<Staff>>();beanParams.put("staffs", staffs);XLSTransformer former = new XLSTransformer();former.transformXLS(srcFilePath, beanParams, destFilePath);System.out.println("the end !!!");}}

运行结束后看生成的Excel文件，template-simple.xlsx

如果是Web,需要下载可以看

 // 下载public static void doDownLoad(String path, String name,HttpServletResponse response) {try {response.reset();response.setHeader("Content-disposition","attachment;success=true;filename ="+ URLEncoder.encode(name, "utf-8"));BufferedInputStream bis = null;BufferedOutputStream bos = null;OutputStream fos = null;InputStream fis = null;File uploadFile = new File(path);fis = new FileInputStream(uploadFile);bis = new BufferedInputStream(fis);fos = response.getOutputStream();bos = new BufferedOutputStream(fos);// 弹出下载对话框int bytesRead = 0;byte[] buffer = new byte[8192];while ((bytesRead = bis.read(buffer, 0, 8192)) != -1) {bos.write(buffer, 0, bytesRead);}bos.flush();fis.close();bis.close();fos.close();bos.close();} catch (Exception e) {e.printStackTrace();}}

最后补充下Excel知识：在单元格里面将日期和时间显示在同一个单元格里面，自定义单元格式→yyyy-m-d hh:mm:ss