springboot - Excel 导出

maven:

 <dependency>
			<groupId>io.github.magic-core</groupId>
			<artifactId>excel-boot</artifactId>
			<version>2.0</version>
		</dependency>

 bean:

package com.jinglitong.springshop.vo;


import com.excel.poi.annotation.ExportField;


public class ExchangeExcel {

	@ExportField(columnName = "标题", defaultCellValue = "")
	private String exchangeName;
	
	@ExportField(columnName = "积分类型", defaultCellValue = "")
	private String integName;
	
	@ExportField(columnName = "兑换码", defaultCellValue = "")
	private String code;
	
	@ExportField(columnName = "失效时间", defaultCellValue = "")
	private String expiryTime;
	
	@ExportField(columnName = "是否过期", defaultCellValue = "")
	private String amount;
	
	@ExportField(columnName = "是否过期", defaultCellValue = "")
	private String expireState;
	
	@ExportField(columnName = "创建时间", defaultCellValue = "")
    private String createTime;
    
	@ExportField(columnName = "是否使用", defaultCellValue = "")
    private String state;
    
	@ExportField(columnName = "使用时间", defaultCellValue = "")
    private String exchangeTime;
	
	@ExportField(columnName = "使用账户", defaultCellValue = "")
    private String account;
}

controller:

@RequestMapping(value = "/exportExcel", method = RequestMethod.GET)
	public void exportExcel(HttpServletResponse response, HttpServletRequest request) throws IOException {
		ExchangeCode2integralVo vo = new ExchangeCode2integralVo();
		if (StringUtils.isNotBlank(request.getParameter("exchangeName"))) {
			vo.setExchangeName(request.getParameter("exchangeName"));
		}
		if (StringUtils.isNotBlank(request.getParameter("integName"))) {
			vo.setIntegName((request.getParameter("integName")));
		}
		if (StringUtils.isNotBlank(request.getParameter("state"))) {
			vo.setState(Integer.valueOf(request.getParameter("state")));
		}
		if (StringUtils.isNotBlank(request.getParameter("expireState"))) {
			vo.setExpireState(Integer.valueOf(request.getParameter("expireState")));
		}

		ExcelBoot.ExportBuilder(response, "Excel文件名", ExchangeExcel.class).exportResponse(vo,
				new ExportFunction<ExchangeCode2integralVo, ExchangeExcel>() {
					@Override
					public List<ExchangeExcel> pageQuery(ExchangeCode2integralVo vo, int pageNum, int pageSize) {
						// 1.将pageNum和pageSize传入使用本组件的开发者自己项目的分页逻辑中

						// 2.调用使用本组件的开发者自己项目的分页查询方法
						List<ExchangeExcel> resultList = exchangeCodeToIntegralService.selectToExcel(vo);

						return resultList;
					}

					/**
					 * 将查询出来的每条数据进行转换
					 *
					 * @param o
					 */
					@Override
					public ExchangeExcel convert(ExchangeExcel o) {
						// 用于编写开发者自定义的转换逻辑
						return o;
					}
				});
	}

over!

导入

@Data
public class UserEntity {
	@ImportField(regexMessage = "areaName")
	private String areaName;
	@ImportField(regexMessage = "district")
	private String district;
	@ImportField(regexMessage = "keyWork")
	private String keyWork;
	@ImportField(regexMessage = "email")
	private String email;
}
public List<UserEntity> importExcel() throws IOException {
		List<UserEntity> list = new ArrayList<UserEntity>();
		ExcelBoot.ImportBuilder(new FileInputStream(new File("D:\\target.xlsx")), UserEntity.class)
				.importExcel(new ImportFunction<UserEntity>() {
					@Override
					public void onProcess(int sheetIndex, int rowIndex, UserEntity userEntity) {
						// 将读取到Excel中每一行的userEntity数据进行自定义处理
						// 如果该行数据发生问题,将不会走本方法,而会走onError方法
						list.add(userEntity);
					}

					@Override
					public void onError(ErrorEntity errorEntity) {
						// 将每条数据非空和正则校验后的错误信息errorEntity进行自定义处理
					}
				});
		return list;
	}

参考官网:

https://github.com/programmeres/excel-boot

以下是SpringBoot整合EasyExcel模板导出Excel的步骤: 1.创建SpringBoot项目 2.在pom.xml文件中添加EasyExcel依赖 ```xml <dependency> <groupId>com.alibaba</groupId> <artifactId>easyexcel</artifactId> <version>2.1.6</version> </dependency> ``` 3.创建Excel模板 4.编写实体类,用于映射Excel中的数据 5.编写Excel导出工具类 ```java public class ExcelUtil { /** * 导出 Excel :一个 sheet,带表头. * * @param sheetName sheet 名称 * @param clazz 实体类对象,通过 annotation 设置标题 * @param data 实体类对象数据 list * @param out 输出流 */ public static void exportExcel(String sheetName, Class clazz, List data, OutputStream out) { ExcelWriter writer = EasyExcelFactory.getWriter(out); //写第一个sheet,sheet1 数据全是List<String> 无模型映射关系 Sheet sheet = new Sheet(1, 0, clazz); sheet.setSheetName(sheetName); //设置自适应宽度 sheet.setAutoWidth(Boolean.TRUE); //写数据到 Writer 上下文中 writer.write(data, sheet); //将上下文中的最终 outputStream 写入到指定文件中 writer.finish(); } } ``` 6.在Controller中调用Excel导出工具类 ```java @GetMapping("/export") public void export(HttpServletResponse response) throws IOException { //查询数据 List<User> userList = userService.getUserList(); //设置文件名 String fileName = "用户信息表"; //设置响应头 response.setContentType("application/vnd.ms-excel"); response.setCharacterEncoding("utf-8"); response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xlsx"); //导出Excel ExcelUtil.exportExcel(fileName, User.class, userList, response.getOutputStream()); } ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值