资源包可以通过,maven项目导入(下面是下载excel相关资源包):
AsposeJavaAPI
Aspose Java API
https://repository.aspose.com/repo/
com.aspose
aspose-cells
19.11
也可以在仓库下载对应的jar包:
https://repository.aspose.com/repo/com/aspose/
excel 加水印的例子:
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_1,
"水印文字", "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.getRed());
//Set the transparency
wordArtFormat.setTransparency(0.9);
//Make the line invisible
MsoLineFormat lineFormat = wordart.getLineFormat();
lineFormat.setVisible(false);
//Save the file
workbook.save(path);
}
待续……