| | |
| | | |
| | | |
| | | public static void main(String[] args) throws Exception { |
| | | String dataPath = "D:\\测评系统\\需求\\LAQ\\report\\LAQ表头数据文件.xlsx"; |
| | | // 获取导入数据 |
| | | File file = new File(dataPath); |
| | | InputStream in = new FileInputStream(file); |
| | | ExcelUtil<LAQTemplate> util = new ExcelUtil<>(LAQTemplate.class); |
| | | List<LAQTemplate> laqTemplateList = util.importExcel(in); |
| | | // String dataPath = "D:\\测评系统\\需求\\LAQ\\report\\LAQ表头数据文件.xlsx"; |
| | | // // 获取导入数据 |
| | | // File file = new File(dataPath); |
| | | // InputStream in = new FileInputStream(file); |
| | | // ExcelUtil<LAQTemplate> util = new ExcelUtil<>(LAQTemplate.class); |
| | | // List<LAQTemplate> laqTemplateList = util.importExcel(in); |
| | | // 生成文件集合 |
| | | List<String> fileNameList = new ArrayList<>(); |
| | | List<String> deleteStrList = new ArrayList<>(); |
| | | for (int i = 0; i < laqTemplateList.size(); i++) { |
| | | LAQTemplate laqTemplate = laqTemplateList.get(i); |
| | | for (int i = 0; i < 1; i++) { |
| | | // LAQTemplate laqTemplate = laqTemplateList.get(i); |
| | | //组装报告所用数据 |
| | | Map<String, Object> textMap = new HashMap<>(); |
| | | // textMap.put("sendEmailFileName",laqTemplate.getName()); |
| | |
| | | // String zipFileName = WordUtil.makeReportFile("D:\\测评系统\\需求\\LAQ\\report\\LAQ英文报告-20230926.docx", template, textMap, new HashMap<>(), deleteStrList); |
| | | // fileNameList.add(zipFileName); |
| | | ZipSecureFile.setMinInflateRatio(0.001); |
| | | try (OutputStream os = new FileOutputStream("D:\\测评系统\\需求\\LAQ\\report\\LAQ英文模板-wzp-修改版-1.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\测评系统\\需求\\LAQ\\report\\LAQ英文模板-wzp-修改版.docx"))){ |
| | | try (OutputStream os = new FileOutputStream("D:\\TaiOS\\LAQ-1.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\TaiOS\\LAQ.docx"))){ |
| | | Map<Integer,List<SeriesData>> seriesDatas = initData(textMap); |
| | | changeChart(document,seriesDatas,textMap); |
| | | document.write(os); |
| | |
| | | |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | log.error("MAQTR替换word图表 散点图图形失败:{}",e); |
| | | log.error("LAQ.替换word图表 散点图图形失败:{}",e); |
| | | } |
| | | } |
| | | |