@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;
}
excel导出
最新推荐文章于 2024-03-07 09:47:44 发布