Jeesite4实现Excel导出_jeesite4导出模板-优快云博客

本文链接：https://blog.youkuaiyun.com/mihe123/article/details/107197084

本文档详细介绍了如何利用Jeesite4框架实现Excel数据导出功能。通过点击页面上的导出按钮，调用控制器方法，设置导出参数，然后使用ExcelExport工具类将查询到的数据写入到Excel文件中，最后返回给客户端进行下载。导出的列包含了设备名称、设备状态、设备编号、设备类型、出厂日期和采购日期等关键信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

页面

$('#btnExport').click(function(){
js.ajaxSubmitForm($('#searchForm'), {
url:'${ctx}/equipment/bequipmentInfo/export',
downloadFile:true
});
});

controller：

@RequiresPermissions("equipment:bequipmentInfo:view")
@RequestMapping(value = "export")
public void exportFile(BequipmentInfo bequipmentInfo, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
try {
String fileName = "报名信息数据"+ DateUtils.getDate("yyyyMMddHHmmss")+".xlsx";
bequipmentInfo.setPage(new Page<>(request, response));
Page<BequipmentInfo> page = bequipmentInfoService.findPage(bequipmentInfo);//这个地方按照这个格式照抄即可

new ExcelExport("报名信息数据", BequipmentInfo.class).setDataList(page.getList()).write(response, fileName);

} catch (Exception e) {
addMessage(redirectAttributes, "导出信息失败！失败信息："+e.getMessage());

}

}

Entity：将要导出的列加上注解

@Valid
@ExcelFields({
@ExcelField(title = "设备名称", attrName = "equipname", align = ExcelField.Align.CENTER, sort = 10, type = ExcelField.Type.EXPORT),
@ExcelField(title = "设备状态", attrName = "equipstatus", align = ExcelField.Align.CENTER, sort = 20, type = ExcelField.Type.EXPORT),
@ExcelField(title = "设备编号", attrName = "equipno", align = ExcelField.Align.CENTER, sort = 30, type = ExcelField.Type.EXPORT),
@ExcelField(title = "设备类型", attrName = "equiptype", align = ExcelField.Align.CENTER, sort = 40, type = ExcelField.Type.EXPORT),
@ExcelField(title = "出厂日期", attrName = "productiondate", align = ExcelField.Align.CENTER, sort = 60, type = ExcelField.Type.EXPORT),
@ExcelField(title = "采购日期", attrName = "buydate", align = ExcelField.Align.CENTER, sort = 70, type = ExcelField.Type.EXPORT),
@ExcelField(title = "生产厂家", attrName = "factory", align = ExcelField.Align.CENTER, sort = 70, type = ExcelField.Type.EXPORT),

})