通过EasyExcel导出excel文件并转为PDF或者其他

第一步导入所需依赖：

   
  
        
            com.e-iceblue
            e-iceblue
            http://repo.e-iceblue.com/nexus/content/groups/public/
        
    


        
        
            com.alibaba
            easyexcel
            2.2.6
        

        
        
            e-iceblue
            spire.xls.free
            2.2.0
        

导出功能，具体业务分离开，我图方便直接在里面写了，反正是测试类demo

package com.shiro.controller;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
import com.shiro.config.HorizontalCellStyleStrategyUtil;
import com.shiro.pojo.User;
import com.shiro.service.UserService;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import java.io.File;
import java.util.HashSet;
import java.util.List;
import java.util.Random;
import java.util.Set;


@Controller
public class EasyExcelController {
    @Autowired
    private UserService service;

    @RequestMapping("/excel")
    public String excelUser() {
        //这个是导出excel样式设置，简单设置一下可以根据自己需要进行设置，工具类下方贴出
        HorizontalCellStyleStrategy horizontalCellStyleStrategy = HorizontalCellStyleStrategyUtil.getHorizontalCellStyleStrategy();
        //所要导出的list
        List list = service.selectList();
        //导出excel文件路径及名称
        String fileName = "D:\javacx\shiro\src\main\resources\static\img\excel\user.xlsx";
        //定义set装所需要导出指定列，名称与实体类里面的字段一致，注意，需要添加注解自动映射，这里只是在映射中指定导出列
        Set names = new HashSet<>();
        names.add("username");
        names.add("password");
        //通过EasyExcel导出为excel表格
        //registerWriteHandler为表格添加样式
        //includeColumnFiledNames指定导出列
        //sheet指定工作簿名称
        //doWrite将查询的list导出
        EasyExcel.write(fileName).head(User.class).registerWriteHandler(horizontalCellStyleStrategy).includeColumnFiledNames(names).sheet("sheet1").doWrite(list);
        //创建Workbook对象
        Workbook workbook = new Workbook();
        //打开指定路径的excel，如果注释掉本行，相当于新建excel
        workbook.loadFromFile(fileName);
        //获取第一个sheet表格
        Worksheet sheet = workbook.getWorksheets().get(0);
        //随机起一个名称
        Random random = new Random();
        String pdf = "D:\javacx\shiro\src\main\resources\static\img\excel\" + random.nextInt(10) + ".pdf";
        //将表格转为pdf
        //这里还有转其他格式方法，可以试试
        sheet.saveToPdf(pdf);
        //创建文件流，将导出的excel文件删除
        File file = new File(fileName);
        file.delete();
        return "/tt/t1";

    }
}

样式工具类

package com.shiro.config;

import com.alibaba.excel.write.metadata.style.WriteCellStyle;
import com.alibaba.excel.write.metadata.style.WriteFont;
import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
import org.apache.poi.ss.usermodel.HorizontalAlignment;


public class HorizontalCellStyleStrategyUtil {
    public static HorizontalCellStyleStrategy getHorizontalCellStyleStrategy() {
        WriteCellStyle headWriteCellStyle = new WriteCellStyle();
        //设置头字体
        WriteFont headWriteFont = new WriteFont();
        headWriteFont.setFontHeightInPoints((short) 13);
        headWriteFont.setBold(true);
        headWriteCellStyle.setWriteFont(headWriteFont);
        //设置头居中
        headWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
        //内容策略
        WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
        //设置 水平居中
        contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
        HorizontalCellStyleStrategy horizontalCellStyleStrategy=new HorizontalCellStyleStrategy(headWriteCellStyle,contentWriteCellStyle);
        return horizontalCellStyleStrategy;
    }
}

实体类

package com.shiro.pojo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;

import java.io.Serializable;


@Data
public class User  implements Serializable {
    private static final long serialVersionUID = 1L;


    //导出注解，value第一个参数为第一行标题名，第二个为列名，index为导出排列顺序
    @ExcelProperty(value = {"用户信息表","编号"},index = 0)
    @TableId(value = "id",type = IdType.AUTO)
    private Integer  id;

    @ExcelProperty(value = {"用户信息表","密码"},index = 2)
    private String password;

    @ExcelProperty(value = {"用户信息表","姓名"},index = 1)
    private String username;


}

以上通过EasyExcel导出excel文件并转为PDF或者图片以及其他格式，是总结了其他博主的知识点实现的，记录一下，方便后续使用与改进。