实现根据搜索条件，导出excel表格信息（vue+java）

vue

<template>
<el-col>
<el-button type="primary" @click="excel()">导出</el-button>
</el-col>
</template>

import querystring from "querystring";
methods: {
	excel(){
      const query = require("querystring")
      let queryExParam = '';
      if(this.exParam){
      	//可自动将json对象转为query串
        queryExParam = '?' +query.stringify(this.exParam);
      }
      let downloadUrl = `${baseUrl}/boss-sms/sms-mt/export${queryExParam}`;
      downloadFile({ url: downloadUrl })
    },
	
	// 公共文件下载
	 downloadFile = ({ url = '' } = {}) => {
	  const aLink = document.createElement('a')
	  aLink.href = url
	  aLink.click()
	  document.body.appendChild(aLink)
	  document.body.removeChild(aLink)
	}
}

java

实体类

package net.qh.boss.sms.dto;


import cn.afterturn.easypoi.excel.annotation.Excel;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;


import java.util.Date;

@Data
public class SmsMtExportDto  {

    private static final long serialVersionUID = 1L;

    @Excel(name = "发送用户", height = 10, width = 20, orderNum = "1")
    private String createBy;

    @Excel(name = "手机号码", height = 10, width = 20, orderNum = "2")
    private String phone;

    @Excel(name = "短信内容", height = 10, width = 20, orderNum = "3")
    private String smsContent;
}

pom

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.2.0</version>
        </dependency>

ExcelStyleUtil

package net.qh.boss.sms.utils;

import cn.afterturn.easypoi.excel.entity.params.ExcelExportEntity;
import cn.afterturn.easypoi.excel.entity.params.ExcelForEachParams;
import cn.afterturn.easypoi.excel.export.styler.IExcelExportStyler;
import org.apache.poi.ss.usermodel.*;

/**
 * @author 王鑫磊
 * @date 2019/11/04
 */
public class ExcelStyleUtil implements IExcelExportStyler {
    private static final short STRING_FORMAT = (short) BuiltinFormats.getBuiltinFormat("TEXT");
    private static final short FONT_SIZE_TEN = 10;
    private static final short FONT_SIZE_ELEVEN = 11;
    private static final short FONT_SIZE_TWELVE = 12;
    /**
     * 大标题样式
     */
    private CellStyle headerStyle;
    /**
     * 每列标题样式
     */
    private CellStyle titleStyle;
    /**
     * 数据行样式
     */
    private CellStyle styles;

    public ExcelStyleUtil(Workbook workbook) {
        this.init(workbook);
    }

    /**
     * 初始化样式
     *
     * @param workbook
     */
    private void init(Workbook workbook) {
        this.headerStyle = initHeaderStyle(workbook);
        this.titleStyle = initTitleStyle(workbook);
        this.styles = initStyles(workbook);
    }

    /**
     * 大标题样式
     *
     * @param color
     * @return
     */
    @Override
    public CellStyle getHeaderStyle(short color) {
        return headerStyle;
    }

    /**
     * 每列标题样式
     *
     * @param color
     * @return
     */
    @Override
    public CellStyle getTitleStyle(short color) {
        return titleStyle;
    }

    /**
     * 数据行样式
     *
     * @param parity 可以用来表示奇偶行
     * @param entity 数据内容
     * @return 样式
     */
    @Override
    public CellStyle getStyles(boolean parity, ExcelExportEntity entity) {
        return styles;
    }

    /**
     * 获取样式方法
     *
     * @param dataRow 数据行
     * @param obj     对象
     * @param data    数据
     */
    @Override
    public CellStyle getStyles(Cell cell, int dataRow, ExcelExportEntity entity, Object obj, Object data) {
        return getStyles(true, entity);
    }

    /**
     * 模板使用的样式设置
     */
    @Override
    public CellStyle getTemplateStyles(boolean isSingle, ExcelForEachParams excelForEachParams) {
        return null;
    }

    /**
     * 初始化--大标题样式
     *
     * @param workbook
     * @return
     */
    private CellStyle initHeaderStyle(Workbook workbook) {
        CellStyle style = getBaseCellStyle(workbook);
        style.setFont(getFont(workbook, FONT_SIZE_TWELVE, true));
        return style;
    }

    /**
     * 初始化--每列标题样式
     *
     * @param workbook
     * @return
     */
    private CellStyle initTitleStyle(Workbook workbook) {
        CellStyle style = getBaseCellStyle(workbook);
        style.setFont(getFont(workbook, FONT_SIZE_ELEVEN, false));
        //背景色
        style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
        style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        return style;
    }

    /**
     * 初始化--数据行样式
     *
     * @param workbook
     * @return
     */
    private CellStyle initStyles(Workbook workbook) {
        CellStyle style = getBaseCellStyle(workbook);
        style.setFont(getFont(workbook, FONT_SIZE_TEN, false));
        style.setDataFormat(STRING_FORMAT);
        style.setFillBackgroundColor(IndexedColors.RED.getIndex());
        style.setFillForegroundColor(IndexedColors.RED.getIndex());
        return style;
    }

    /**
     * 基础样式
     *
     * @return
     */
    private CellStyle getBaseCellStyle(Workbook workbook) {
        CellStyle style = workbook.createCellStyle();
        //下边框
        style.setBorderBottom(BorderStyle.THIN);
        //左边框
        style.setBorderLeft(BorderStyle.THIN);
        //上边框
        style.setBorderTop(BorderStyle.THIN);
        //右边框
        style.setBorderRight(BorderStyle.THIN);
        //水平居中
        style.setAlignment(HorizontalAlignment.CENTER);
        //上下居中
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        //设置自动换行
        style.setWrapText(true);
        return style;
    }

    /**
     * 字体样式
     *
     * @param size   字体大小
     * @param isBold 是否加粗
     * @return
     */
    private Font getFont(Workbook workbook, short size, boolean isBold) {
        Font font = workbook.createFont();
        //字体样式
        font.setFontName("宋体");
        //是否加粗
        font.setBold(isBold);
        //字体大小
        font.setFontHeightInPoints(size);
        return font;
    }
}

Controller

@GetMapping("/export")
    @ApiOperation("excel导出")
    public void  export(SmsMtSearchVo  searchVo, HttpServletResponse response) {
        smsMtService.export(searchVo,response);
    }

ServiceImpl

@Override
    public void export(SmsMtSearchVo searchVo, HttpServletResponse response) {

        //文件名
        String sheetName = "短信发送记录_" + DateUtil.format(new Date(), "yyyy-MM-dd");
        try (OutputStream out = response.getOutputStream()){
            response.getOutputStream();
            ExportParams params = new ExportParams(null, sheetName, ExcelType.XSSF);
            params.setTitleHeight((short) 20);

            params.setStyle(ExcelStyleUtil.class);

            //查询结果
            List<SmsMtDto> smsMtDtos = this.selectSmsMtList(searchVo);
            //拷贝查询结果list给导出结果
            List<SmsMtExportDto> numberExportDTOS = smsMtDtos.stream().map(item -> {
                SmsMtExportDto exportDto = CopyUtils.INSTANCE.map(SmsMtExportDto.class, item);

                exportDto.setCreateTime(DateUtil.format(item.getCreateTime(), "yyyy-MM-dd 
                return exportDto;
            }).collect(toList());

            Workbook workbook = ExcelExportUtil.exportExcel(params, SmsMtExportDto.class, numberExportDTOS);

            response.setContentType("application/octet-stream");
            response.setHeader("Content-disposition", "attachment; filename="
                    + new String((sheetName + ".xlsx").getBytes("GBK"), "ISO-8859-1"));
            //输出结果集
            workbook.write(out);
        } catch (Exception e) {
            e.printStackTrace();
        }


    }