本文共 4274 字，大约阅读时间需要 14 分钟。

添加的maven依赖：

   		
   			
    
     org.jxls
    			
    
     jxls-poi
    			
    
     ${jxsl.poi.version}
    		
   		
   			
    
     org.jxls
    			
    
     jxls
    			
    
     ${jxls.version}
    		
   		
   			
    
     org.jxls
    			
    
     jxls-reader
    			
    
     2.0.3
    		
   

导出模板类：

package com.ismartgo.uqcode.common.utils;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.util.Map;import org.apache.commons.logging.Log;import org.apache.commons.logging.LogFactory;import org.jxls.common.Context;import org.jxls.util.JxlsHelper;/** * JXSL excel模板工具方法 * 
 * JXSL detail please see http://jxls.sourceforge.net/
 * User: Foy Lian * Date: 2017-07-04 * Time: 17:44 */public class JxlsTemplate {    /**     * 模板路径     */    private static final String TEMPLATE_DIR = "/excel";    protected static Log logger = LogFactory.getLog(JxlsTemplate.class);    /**     * 使用JxlsTemplate.class.getResourceAsStream load 模板     *     * @param template 模板名称，相当于TEMPLATE_DIR设置的路径     * @param out      生成excel写入的输出流     * @param params   交给jxls处理模板需要的参数     * @throws IOException     */    public static void processTemplate(String template, OutputStream out, Map
   
     params) throws IOException {        processTemplate(JxlsTemplate.class, template, out, params);    }    /**     * 使用resourceBaseClassgetResourceAsStream load 模板     *     * @param resourceBaseClass class load的类     * @param template          模板名称     * @param out               生成excel写入的输出流     * @param params            交给jxls处理模板需要的参数     * @throws IOException     */    public static void processTemplate(Class resourceBaseClass, String template, OutputStream out, Map
    
      params) throws IOException {        InputStream in = resourceBaseClass.getResourceAsStream(TEMPLATE_DIR + template);        if (null == in) {            logger.error("can't find excel template by path:" + TEMPLATE_DIR + template);            throw new TemplateNotFoundException("找不到excel模板！,位置:" + TEMPLATE_DIR + template);        }        processTemplate(in, out, params);    }    /**     * @param templateStream excel模板流     * @param out            生成excel写入的输出流     * @param context        jxsl上下文     * @throws IOException     */    private static void processTemplate(InputStream templateStream, OutputStream out, Context context) throws IOException {        JxlsHelper.getInstance().processTemplate(templateStream, out, context);    }    /**     * @param templateStream excel模板流     * @param out            生成excel写入的输出流     * @param params         交给jxls处理模板需要的参数     * @throws IOException     */    public static void processTemplate(InputStream templateStream, OutputStream out, Map
     
       params) throws IOException {        Context context = new Context();        if (params != null) {            for (String key : params.keySet()) {                context.putVar(key, params.get(key));            }        }        processTemplate(templateStream, out, context);    }}
     
    
   

Controller类导出接口方法：

@RequestMapping(value="/export", method = RequestMethod.GET)	public void export(HttpServletResponse response,HttpServletRequest req) {		AuthUser user = (AuthUser) req.getSession().getAttribute("loginUser");		UqcProduct product = new UqcProduct();		//product.setSysTenantCode(user.getSysTenantCode());		product.setSysTenantCode("1");		ServletOutputStream out = null;		SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");		List
   
     list = productService.queryList(product);		Map
    
      params = new HashMap
     
      ();		params.put("items", list);		try {			response.setHeader("Expires", "0");			response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");			response.setHeader("Content-Disposition", "attachment; filename=\"product.xls\"");			response.setHeader("Pragma", "public");			response.setContentType("application/x-excel;charset=UTF-8");			out = response.getOutputStream();			JxlsTemplate.processTemplate("/productList_export.xls", out, params);			out.flush();			out.close();		} catch (Exception e) {			e.printStackTrace();		}	}
     
    
   

Excel模板：

Excel模板添加的批注：上图ID批注：zsy:jx:area(lastCell="N2")

${item.id}的批注：zsy:jx:each(items="items" var="item" lastCell="N2")

模板识别到Controller传入的items值进行for循环进行值得填充

转载地址：http://xpbai.baihongyu.com/