通过EasyExcel导出excel文件并转为PDF或者其他 |
您所在的位置：网站首页 › Excel转变成PDF › 通过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; /** * @author qb * @version 1.0 * go on!!! * @date 2021/9/16 8:56 */ @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; /** * @author qb * @version 1.0 * go on!!! * @date 2021/9/16 10:28 */ 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; /** * @author qb * @version 1.0 * go on!!! * @date 2021/8/21 16:49 */ @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或者图片以及其他格式，是总结了其他博主的知识点实现的，记录一下，方便后续使用与改进。 |
今日新闻 |
推荐新闻 |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |