excel导出

	@RequestMapping("/export")
    public void export(@RequestParam Map<String,Object> params,HttpServletResponse response) throws IOException {
    	//实体类结果集
        List<Entity> list = entityService.queryList(params);

        response.setHeader("content-Type", "application/vnd.ms-excel");
        //xls名称
        response.setHeader("Content-Disposition",
                "attachment;filename=" + URLEncoder.encode("实体类导出记录表", "UTF-8") + ".xls");
        response.setCharacterEncoding("UTF-8");
        //sheet 名称
        ExportParams exportParams = new ExportParams("用户信息", "数据");
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, Entity.class, list);
        workbook.write(response.getOutputStream());
    }


import org.jeecgframework.poi.excel.annotation.Excel;

import java.io.Serializable;
import java.util.Date;

public class Entity implements Serializable{

    private static final long serialVersionUID = 69568462548L;

    private Integer id;
    @Excel(name = "名称",orderNum = "1",isImportField = "name",width=30)
    private String name;
    @Excel(name = "电话",orderNum = "2",isImportField = "typeValue",width=30)
    private String phone;
    @Excel(name = "地址",orderNum = "4",isImportField = "typeValue",width=30)
    private String address;
}