123456789101112131415161718192021222324252627282930313233343536373839404142 |
- package net.lab1024.smartadmin.common.controller;
- import lombok.extern.slf4j.Slf4j;
- import org.apache.poi.ss.usermodel.Workbook;
- import javax.servlet.http.HttpServletResponse;
- import java.io.IOException;
- import java.io.UnsupportedEncodingException;
- import java.net.URLEncoder;
- /**
- * @author: zhuoda
- * @create: 2020-03-31 08:54 PM from win10
- */
- @Slf4j
- public class BaseController {
- /**
- * 下载 Excel 消息头
- * @param fileName
- * @param workbook
- * @param response
- */
- public void downloadExcel(String fileName, Workbook workbook, HttpServletResponse response) {
- try {
- fileName = URLEncoder.encode(fileName, "UTF-8");
- } catch (UnsupportedEncodingException e) {
- log.error("", e);
- }
- response.setCharacterEncoding("utf-8");
- response.setHeader("Content-Type", "application/vnd.ms-excel");
- response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
- try {
- workbook.write(response.getOutputStream());
- workbook.close();
- } catch (IOException e) {
- log.error("", e);
- }
- }
- }
|