com.haoxuer.discover.views.excel.JxlsExcelView Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of discover-excel-view Show documentation

There is a newer version: 3.3.18-20230117

package com.haoxuer.discover.views.excel;

import org.springframework.web.servlet.view.AbstractView;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.Map;
import org.jxls.common.Context;
import org.jxls.util.JxlsHelper;

public class JxlsExcelView extends AbstractView {


  private static final String CONTENT_TYPE = "application/vnd.ms-excel";

  private String templatePath;
  private String exportFileName;

  /**
   * @param templatePath   模版相对于当前classpath路径
   * @param exportFileName 导出文件名
   */
  public JxlsExcelView(String templatePath, String exportFileName) {
    this.templatePath = templatePath;
    if (exportFileName != null) {
      try {
        exportFileName = URLEncoder.encode(exportFileName, "UTF-8");
      } catch (UnsupportedEncodingException e) {
        e.printStackTrace();
      }
    }
    this.exportFileName = exportFileName;
    setContentType(CONTENT_TYPE);
  }



  @Override
  protected void renderMergedOutputModel(
      Map model,
      HttpServletRequest request,
      HttpServletResponse response) throws Exception {
    Context context = new Context(model);
    response.setContentType(getContentType());
    response.setHeader("content-disposition",
        "attachment;filename=" + exportFileName + ".xls");
    ServletOutputStream os = response.getOutputStream();
    InputStream is = getClass().getClassLoader().getResourceAsStream(templatePath);
    JxlsHelper.getInstance().processTemplate(is, os, context);
    is.close();
  }

}