Java导出excel基于注解

最新推荐文章于 2025-07-17 15:50:36 发布

1210fei

最新推荐文章于 2025-07-17 15:50:36 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： java基础代码文章标签： excel java

本文链接：https://blog.youkuaiyun.com/benben574599386/article/details/78690748

java基础代码专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一种使用JavaScript实现在前端导出数据到Excel的方法，并详细展示了从调用导出函数到后端处理及返回文件的完整流程。

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

js中的方法：

// 导出日志
exportLog:function(e){
debugger
fly.top.fly.dialog({
title: '导出',
content: '是否导出？',
width: '240px',
padding: '30px 20px',
okValue: '确认',
cancelValue: '取消',
ok: function() {
util.mask('文件正在导出...');
window.location.href=CONTEXTPATH + '/originalhitch/exportLog.do?hitchId=' + id;
util.removeMask()
},
cancel: true
});
},

控制层，我是因为根据id来查询数据的

@RequestMapping(value = "/exportLog.do", produces = "application/json;charset=UTF-8")
@ResponseBody
public String exportLog(HttpServletRequest request,HttpServletResponse response, String hitchId) {
try {
String filepath=request.getRealPath("/")+"upload/";

String path= originalHitchService.exportItem(hitchId,filepath);
String name="原文挂接详情";
String sux="";
if(path.contains(".")){
sux=path.substring(path.lastIndexOf("."),path.length());
}
OutputStream out = response.getOutputStream();
byte[] fileData = FileUtils.fileToBytes(path);
String filename = new String(
URLEncoder.encode(name+sux, "UTF-8")
.getBytes("UTF-8"),
"ISO8859-1");
response.setHeader("content-disposition", "attachment;filename=" + filename);
// 写明要下载的文件的大小
response.setContentLength(fileData.length);
out.write(fileData);
out.flush();
out.close();
} catch (Exception e) {
logger.error("导出日志异常:" + e.getMessage(), e);
return JSONUtil.error();
}
return JSONUtil.success();
}

实现层方法：

@Override
public String exportItem(String hitchId,String filepath) throws Exception {
List<HsdaOriginalHitchDetail> originalHitchDetails =originalHitchDetailDao.queryListByHitchId(hitchId);
HitchLogExcel hitchLogExcel;
String path;
List<HitchLogExcel> list = new ArrayList<>();
for (HsdaOriginalHitchDetail originalHitchDetail : originalHitchDetails) {
hitchLogExcel = new HitchLogExcel();
hitchLogExcel.setFileNum(StringUtil.isNotEmpty(originalHitchDetail.getFileNum()) ? originalHitchDetail.getFileNum() : "");
hitchLogExcel.setRecordTitle(StringUtil.isNotEmpty(originalHitchDetail.getRecordTitle()) ?originalHitchDetail.getRecordTitle() : "");
hitchLogExcel.setRecordPageNum(StringUtil.isNotEmpty(originalHitchDetail.getRecordNum()) ?originalHitchDetail.getRecordNum() : "");
hitchLogExcel.setOriginalNum(StringUtil.isNotEmpty(originalHitchDetail.getOriginalNum()) ?originalHitchDetail.getOriginalNum() : "");
if (StringUtil.isNotEmpty(originalHitchDetail.getMatchStatus())) {
hitchLogExcel.setMatchStatus(PublicZdCacheLoadImpl.getDictMc("PPZT", originalHitchDetail.getMatchStatus(), false));
} else {
hitchLogExcel.setMatchStatus("");
}
if (StringUtil.isNotEmpty(originalHitchDetail.getHitchStatus())) {
hitchLogExcel.setHitchStatus(PublicZdCacheLoadImpl.getDictMc("GJZT", originalHitchDetail.getHitchStatus(), false));
} else {
hitchLogExcel.setHitchStatus("");
}
if (StringUtil.isNotEmpty(originalHitchDetail.getCheckoutResult())) {
hitchLogExcel.setCheckoutResult(PublicZdCacheLoadImpl.getDictMc("YZXJY", originalHitchDetail.getCheckoutResult(), false));
} else {
hitchLogExcel.setCheckoutResult("");
}
list.add(hitchLogExcel);
}
try {
path=filepath+"/"+ ComDateUtils.getDate() + TokenUtils.getRandom() + ".xlsx";
ExcelUtil.writeToFile(list, null, path);
} catch (Exception e) {
e.printStackTrace();
return "";
}
return path;
}

需要转换的excel对象：

public class HitchLogExcel {
/**
*档号
*/
@Excel(name = "档号", width = 20,length = 50)
private String fileNum;
/**
*著录题名
*/
@Excel(name = "著录题名", width = 20,length = 50)
private String recordTitle;
/**
*著录页数
*/
@Excel(name = "著录页数", width = 20,length = 50)
private String recordPageNum;
/**
* 文件页数
*/
@Excel(name = "文件页数", width = 20,length = 50)
private String originalNum;
/**
*匹配状态
*/
@Excel(name = "匹配状态", width = 20,length = 50)
private String matchStatus;
/**
* 挂接状态
*/
@Excel(name = "挂接状态", width = 20,length = 50)
private String hitchStatus;
/**
* 一致性检验
*/
@Excel(name = "一致性检验", width = 20,length = 50)
private String checkoutResult;

getter/setter方法。。。。

｝

Excel注解，用以生成Excel表格文件

@Retention(RetentionPolicy.RUNTIME)
@Target({ElementType.FIELD,ElementType.TYPE})
public @interface Excel {

//列名
String name() default "";

//宽度
int width() default 20;

//忽略该字段
boolean skip() default false;

//字符长度
int length() default 100;

//是否必填
boolean must() default false;

//是否是日期
boolean date() default false;

}