easyPoi的简单导出操作

@小小鸟

esaypoi的导出

easypoi功能如同名字easy,主打的功能就是容易,让一个没见接触过poi的人员
就可以方便的写出Excel导出,Excel模板导出,Excel导入,Word模板导出,通过简单的注解和模板
语言(熟悉的表达式语法),完成以前复杂的写法。

@GetMapping(value = "/excelList", name = "导出需求数据")
    public void ExcelList(HttpServletRequest request, HttpServletResponse response,HrCreditsVolumeLibraryForm form) {
    	Map<String, Object> map = new HashMap<String, Object>();
    	List<HrCreditsVolumeLibraryOutExcelModel> list = hrCreditsVolumeLibraryService.excelList(form);
    	ExportParams params = new ExportParams();   
    	params.setSheetName("XX表单");    //设置标题
        params.setHeaderColor(HSSFColor.BLUE.index);
        map.put(NormalExcelConstants.FILE_NAME, "xx管理-"+new SimpleDateFormat("yyyy-MM").format(new Date()));  //设置文件导出名称
        map.put(NormalExcelConstants.DATA_LIST, list);
        map.put(NormalExcelConstants.CLASS, HrCreditsVolumeLibraryOutExcelModel.class);
        map.put(NormalExcelConstants.PARAMS, params);
        PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);
    }

其中的HrCreditsVolumeLibraryOutExcelModel是你要到处的模板类

package com.coreland.eip.motivationSystem.modules.systemManagement.response.model;

import java.io.Serializable;


import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import lombok.Getter;
import lombok.Setter;

@ExcelTarget("driverModel")
public class HrCreditsVolumeLibraryOutExcelModel implements Serializable{
	private static final long serialVersionUID = 1L;
	
	@Excel(name = "券码名称", width = 40)
	@Setter
	@Getter
	private String volumeName;
	
	@Excel(name = "券码分类", width = 40)
	@Setter
	@Getter
	private String volumeType;
	
	...........

}

很简单的操作，希望能帮到你们## easypoi的导出操作