Execl
AdolfQiu
激流勇进才能领略江河源头的奇观胜景!
展开
-
按周统计数据并且导出案例-前端layui加后端POI
前端效果:导出效果:后端代码:controller层: @RequestMapping(value = "/exportResearchXls") @ResponseBody public void exportResearchXls(HttpServletRequest request) { User user = SuperKit.getLoginedUser(request); IContextDictionary dict..原创 2020-11-26 11:16:05 · 344 阅读 · 0 评论 -
POI导出之我的实践篇2-用List集合和Map集合封装工具类
1、引入依赖 <dependency> <groupId>com.thoughtworks.xstream</groupId> <artifactId>xstream</artifactId> <version>1.4.10</version> </dependency> <dependency> <groupId>org.apache.poi<.原创 2020-11-19 12:13:26 · 321 阅读 · 0 评论 -
POI导出之生成EXCEL保存到指定目录
private void dealExcelExport(String pk,String fullPath) { DataTable dataTable = DBManager.getDataTable(new Sql("select META_NAME as metaName,OTEXT as otext,TTEXT as ttext,ACT_TIME as actTime,CREATE_UNAME as createUname,CREATE_DEPTNAME as createDeptnam.原创 2020-11-18 10:12:45 · 1127 阅读 · 0 评论 -
POI导出之使用Springboot导出Excel和Word导出功能一体
第一步:引入依赖包<properties> <java.version>1.8</java.version> <poi.version>3.15</poi.version></properties><!-- word相关--> <dependency> <groupId>org.freemarker</groupI原创 2020-11-14 09:34:00 · 222 阅读 · 1 评论 -
POI导出之我的实践篇
做了不少Excel导出 终于弄能够灵活运用POI实现Excel导出了,下面是我的实践案例。可以根据下面代码进行整合:String[] titles = new String[]{"序号","档号","文号","责任者","题名","日期","密级","页数","备注"}; String[] titlesvar = new String[]{"order","dh","wh","zrz","tm","rq","mj","ys","bz"}; List<Map<.原创 2020-11-12 14:05:07 · 1010 阅读 · 14 评论 -
POI导出之运用反射封装导出工具类:包含不同版本下载、日期内容处理格式、下载某个路径的Excel、保存Excel到某个路径
DataTable dataTable = DBManager.getDataTable(new Sql("SELECT ELEARCHIVEFILECODE,BT,ARCHIVEYEAR,DEOTORPROBLEM,BMQX_TEXT,MJ_TEXT,ISPUBLIC_TEXT,NGDW,FWH,CWRQ,GWYS,NGR,NGRQ,ZTC,PUBLICTYPE_TEXT,QZH,HAVEPAPERS,HAVEPAPERS_TEXT,DYFS FROM OA_ARCHIVES WHERE ID IN...原创 2020-11-11 19:17:15 · 226 阅读 · 0 评论