POI操作word与excel

知识沉淀

已于 2023-09-16 15:52:44 修改

阅读量470

点赞数

文章标签： excel java

于 2023-09-16 15:50:39 首次发布

本文链接：https://blog.csdn.net/qq_36512904/article/details/132919389

版权

文章目录

一、poi生成word文档

1.构建文档数据

//数据信息
Map<String, Object> map = new HashMap<>();
map.put("gradeReportName", gradeReportInfo.getGradeReportName());
map.put("createTimeStr", DateUtil.toString(gradeReportInfo.getCreateTime()));
//图片信息
List<String> impPathList = new ArrayList<>();
boolean buildFlag = getWord('文件路径', '模板名称', 'word文件名称', map,impPathList);

2.生成word文档

public static boolean getWord(String uploadFilePath, String templateName, String wordName, Map<String, Object> dataMap,List<String> imgPathList) {
    	boolean buildFlag = true;
    	//生成的word文档路径
    	String docxPath = uploadFilePath + File.separator + wordName;
    	//加载模板文件
    	String templateOutPath = uploadFilePath + File.separator + templateName;
    	//构建图片信息
    	if (CollectionUtil.isNotEmpty(imgPathList)) {
    		dataMap.put("imgList", getImgList(imgPathList));
		}
    	FileOutputStream in = null;
    	XWPFTemplate template = null;
    	try {
			template = XWPFTemplate.compile(templateOutPath).render(
				new HashMap<String, Object>(){{
					for (Map.Entry<String, Object> map : dataMap.entrySet()) {
						put(map.getKey(), map.getValue());
					}
				}}
			);
			in = new FileOutputStream(docxPath);
			template.writeAndClose(in);
    	} catch (Exception e) {
			log.error("poi生成word文档异常",e);
			buildFlag = false;
		} finally {
			FileUtil.closeStream(in);
			try {
				template.close();
			} catch (IOException e) {
				log.error("XWPFTemplate对象关闭异常",e);
			}
		}
		return buildFlag;
    }

3.图片信息处理

public static List<Map<String, Object>> getImgList(List<String> imgPathList){
    	List<Map<String, Object>> imgMapList = new ArrayList<>();
		Map<String, Object> dataMap = null;
		List<Map<String, Object>> picList = new ArrayList<>();
		Map<String, Object> imageMap = null;
		//获取网络情况图片信息
	    if (CollectionUtil.isNotEmpty(imgPathList)) {
	    	dataMap = new HashMap<>();
	    	for (String filePath : imgPathList) {
	    		imageMap = new HashMap<>();
	    		imageMap.put("image", Pictures.ofLocal(filePath).fitSize().create());
	    		picList.add(imageMap);
			}
	    	dataMap.put("images", picList);
	    	imgMapList.add(dataMap);
	    }
	    return imgMapList;
}

二、poi实现word转pdf

public static boolean wordCovertPdf(String uploadFilePath,String destFileDir,String wordName,String pdfName,boolean isCreateFont) {
		log.info("start word covert pdf-------");
		boolean covertFlag = true;
		InputStream in = null;
		OutputStream outPDF = null;
		try {
	        in = Files.newInputStream(Paths.get(destFileDir + File.separator + wordName));
	        XWPFDocument document = new XWPFDocument(in);
	        //设置字体
	        if (isCreateFont) {
	        	createFile(uploadFilePath, "arialuni.ttf", false, "classpath*:template/");
			}
	        PdfOptions pdfOptions = PdfOptions.create();
	        pdfOptions.fontProvider(new IFontProvider() {
				String tempPath = uploadFilePath;
				public Font getFont(String familyName, String encoding, float size, int style, Color color) {
					try {
						if (!tempPath.endsWith("/")) {
							tempPath += "/";
						}
						BaseFont bfChinese = BaseFont.createFont(tempPath + File.separator + "arialuni.ttf", BaseFont.IDENTITY_H,
								BaseFont.EMBEDDED);
						Font fontChinese = new Font(bfChinese, size, style, color);
						if (familyName != null) {
							fontChinese.setFamily(familyName);
						}
						return fontChinese;
					} catch (Exception e) {
						log.error("getFont-error", e);
						return null;
					}
				}
			});
	        outPDF = Files.newOutputStream(Paths.get(destFileDir + File.separator + pdfName));
			PdfConverter.getInstance().convert(document, outPDF, pdfOptions);
	    } catch (Exception e) {
	    	log.error("word 转 pdf 异常");
		    log.error(e.getMessage(),e);
		    covertFlag = false;
	    } finally {
			FileUtil.closeStream(in);
			FileUtil.closeStream(outPDF);
		}
		log.info("end word covert pdf-------");
		return covertFlag;
	}

三、poi实现excel转pdf

public static boolean excelCovertPdf(String uploadFilePath,String destFileDir,String excelName, String pdfName,boolean isCreateFont) {
		log.info("start excel covert pdf-------");
		boolean covertFlag = true;
        PdfFont pdfFont = null;
        InputStream in = null;
        try (PdfDocument pdf = new PdfDocument(new PdfWriter(new FileOutputStream(destFileDir + File.separator + pdfName)));
                Document document = new Document(pdf, PageSize.A2.rotate());) 
        {
        	//设置字体
        	if (isCreateFont) {
        		createFile(uploadFilePath, "arialuni.ttf", true, "classpath*:template/");
			}
        	pdfFont = PdfFontFactory.createFont(uploadFilePath + File.separator + "arialuni.ttf");
            String type = "xls".equals(getSuffix(destFileDir + File.separator + excelName).trim()) ? "org.apache.poi.hssf.usermodel.HSSFWorkbook"
                    : "org.apache.poi.xssf.usermodel.XSSFWorkbook";
            // 文件输入流读取文件
            in = new FileInputStream(destFileDir + File.separator + excelName);
            // 反射创建workbook
            Class workbookClass = Class.forName(type);
            org.apache.poi.ss.usermodel.Workbook workbook = (org.apache.poi.ss.usermodel.Workbook) workbookClass
                    .getConstructor(InputStream.class).newInstance(in);
            Sheet sheet = workbook.getSheetAt(0);
            int row = sheet.getPhysicalNumberOfRows();
            int maxColumn=0;
            for (int q = sheet.getFirstRowNum(); q <=row+1; q++) {
                Row r =  sheet.getRow(q);
                if(r==null){
                    continue;
                }
                org.apache.poi.ss.usermodel.Cell firstCell = sheet.getRow(q).getCell(0);
                if(firstCell==null){
                    continue;
                }
                int currentRowMaxColumn = sheet.getRow(q).getLastCellNum();
                org.apache.poi.ss.usermodel.Cell cell = sheet.getRow(q).getCell(currentRowMaxColumn-1);
                if(cell==null){
                    continue;
                }else{
                    maxColumn = maxColumn>currentRowMaxColumn?maxColumn:currentRowMaxColumn;
                }
            }
            int column = maxColumn;
            Table table = new Table(column);
            String str = null;
            boolean addHeadFlag = false;
            for (int i = sheet.getFirstRowNum(); i <= row+1;i++) {
                Row r =  sheet.getRow(i);
                if(r==null){
                    continue;
                }
                for (int j = 0; j < column; j++) {
                    // 获取excel单元格
                    org.apache.poi.ss.usermodel.Cell cell = sheet.getRow(i).getCell(j);
                    if (cell!=null && cell.getCellType() == CellType.NUMERIC) {
                        str = cell.getNumericCellValue()+"";
                    }else if(cell!=null ){
                        str = cell.getStringCellValue();
                    }else{
                        str = null;
                    }
                    if(cell==null && j==0){
                        continue;
                    }else if(cell==null){
                        Cell cells = new Cell().setFont(pdfFont).add(new Paragraph(""));
                        table.addCell(cells);
                    }else if(str!=null && str.contains("报表") && (i==sheet.getFirstRowNum() || i==sheet.getFirstRowNum()+1) && addHeadFlag ){
                        Cell cells = new Cell().setFont(pdfFont).add(new Paragraph(""));
                        table.addCell(cells);
                    }else{
                        if (cell.getCellType() == CellType.NUMERIC) {
                            str = (int) cell.getNumericCellValue() + "";
                        } else {
                            str = cell.getStringCellValue();
                        }
                        Cell cells = new Cell().setFont(pdfFont).add(new Paragraph(str));
                        cells.setFontSize(14);//设置字体大小
                        table.addCell(cells);
                        addHeadFlag = true;
                    }
                }
            }
            document.add(table);
        } catch (Exception e) {
        	log.error("excel 转 pdf 异常");
            log.error(e.getMessage(),e);
            covertFlag = false;
        } finally {
			FileUtil.closeStream(in);
		}
        log.info("end excel covert pdf-------");
        return covertFlag;
    }