利用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