使用itextpdf将excel转化为pdf + pdf加水印

package com.aspose.cells; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.InputStream; public class TestForExcel2PDF { public static void main(String[] args) throws Exception { String sourceFilePath="e:/1.xlsx"; String desFilePath="e:/1.pdf"; // addWaterMark4Excel(sourceFilePath); excel2pdf(sourceFilePath, desFilePath); } public static void addWaterMark4Excel(String path) throws Exception { FileInputStream is = new FileInputStream(path); com.aspose.cells.Workbook workbook = new com.aspose.cells.Workbook(is); //Get the first default sheet Worksheet sheet = workbook.getWorksheets().get(0); //Add Watermark Shape wordart = sheet.getShapes().addTextEffect( MsoPresetTextEffect.TEXT_EFFECT_11,"内部资料", "Arial Black", 50, false, true , 18, 8, 1, 1, 130, 800); //Get the fill format of the word art MsoFillFormat wordArtFormat = wordart.getFillFormat(); //Set the color wordArtFormat.setForeColor(com.aspose.cells.Color.getGray()); //Set the transparency wordArtFormat.setTransparency(0.5); //Make the line invisible MsoLineFormat lineFormat = wordart.getLineFormat(); lineFormat.setVisible(false); //Save the file workbook.save(path); } /** * 获取license 去除水印 * @return */ public static boolean getLicense() { boolean result = false; try { InputStream is = TestForExcel2PDF.class.getClassLoader().getResourceAsStream("\\license.xml"); License aposeLic = new License(); aposeLic.setLicense(is); result = true; } catch (Exception e) { e.printStackTrace(); } return result; } /** * excel 转为pdf 输出。 * * @param sourceFilePath excel文件 * @param desFilePathd pad 输出文件目录 */ public static void excel2pdf(String sourceFilePath, String desFilePathd ){ if (!getLicense()) { // 验证License 若不验证则转化出的pdf文档会有水印产生 return; } try { Workbook wb = new Workbook(sourceFilePath);// 原始excel路径 FileOutputStream fileOS = new FileOutputStream(desFilePathd); PdfSaveOptions pdfSaveOptions = new PdfSaveOptions(); pdfSaveOptions.setOnePagePerSheet(true); int[] autoDrawSheets={3}; //当excel中对应的sheet页宽度太大时，在PDF中会拆断并分页。此处等比缩放。 // autoDraw(wb,autoDrawSheets); int[] showSheets={0}; //隐藏workbook中不需要的sheet页。 printSheetPage(wb,showSheets); wb.save(fileOS, pdfSaveOptions); fileOS.flush(); fileOS.close(); System.out.println("完毕"); } catch (Exception e) { e.printStackTrace(); } } /** * 设置打印的sheet 自动拉伸比例 * @param wb * @param page 自动拉伸的页的sheet数组 */ public static void autoDraw(Workbook wb,int[] page){ if(null!=page&&page.length>0){ for (int i = 0; i < page.length; i++) { wb.getWorksheets().get(i).getHorizontalPageBreaks().clear(); wb.getWorksheets().get(i).getVerticalPageBreaks().clear(); } } } /** * 隐藏workbook中不需要的sheet页。 * @param wb * @param page 显示页的sheet数组 */ public static void printSheetPage(Workbook wb,int[] page){ for (int i= 1; i < wb.getWorksheets().getCount(); i++) { wb.getWorksheets().get(i).setVisible(false); } if(null==page||page.length==0){ wb.getWorksheets().get(0).setVisible(true); }else{ for (int i = 0; i < page.length; i++) { wb.getWorksheets().get(i).setVisible(true); } } } }