POI注解导出JAR包整合,只需简单10行以内代码,搞定复杂POI导出EXCEL表。
1,导入jar包,工具包,poi相关,谷歌gauava,spring-commons-codece。
2.导出实体类加入注解,字段GET方法上
@ExcelField(title = "名称", type = 1, align = 2, sort = 1)
public String getName() {
return name;`
}
3,写导出方法:
需要用HttpServletRequest 和HttpServletResponse
public List<ReportOvertime> export(HttpServletRequest request, HttpServletResponse response){
System.err.println(reportOvertimeList.toString());
String Browser = "";
String UserAgent = request.getHeader("USER-AGENT").toLowerCase();
if (UserAgent != null) {
if (UserAgent.indexOf("msie") >= 0)
Browser = "IE";
if (UserAgent.indexOf("firefox") >= 0)
Browser = "FF";
if (UserAgent.indexOf("safari") >= 0)
Browser = "SF";
}
ArrayList<实体类> arrayList = new ArrayList<实体类>();
arrayList.add(outServiceDtlHead);
String fileName = "文件名" + ".xlsx";
try {
new ExportExcel("表头", OutServiceDtlHead.class).setDataList(
arrayList).write(response, fileName,Browser).dispose();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}