springboot - Excel 导出

最新推荐文章于 2021-08-16 18:16:34 发布

y_index

最新推荐文章于 2021-08-16 18:16:34 发布

阅读量335

点赞数

分类专栏： biubiu

本文链接：https://blog.csdn.net/y_index/article/details/99590990

版权

biubiu 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

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