Adding Watermark to Excel

// Load the Excel file
Workbook workbook = new Workbook("Excel.xlsx");

// Get the first default sheet
Worksheet sheet = workbook.getWorksheets().get(0);

// Add watermark
Shape wordart = sheet.getShapes().addTextEffect(MsoPresetTextEffect.TEXT_EFFECT_1, "CONFIDENTIAL",
		"Arial Black", 50, false, true, 18, 8, 1, 1, 130, 800);

// Get the fill format of the word art
FillFormat wordArtFormat = wordart.getFill();

// Set the color
wordArtFormat.setOneColorGradient(Color.getRed(), 0.2, GradientStyleType.HORIZONTAL, 2);

// Set the transparency
wordArtFormat.setTransparency(0.9);

// Make the line invisible
wordart.setHasLine(false);

// Lock shape aspects
wordart.setLocked(true);
wordart.setLockedProperty(ShapeLockType.SELECTION, true);
wordart.setLockedProperty(ShapeLockType.SHAPE_TYPE, true);
wordart.setLockedProperty(ShapeLockType.MOVE, true);
wordart.setLockedProperty(ShapeLockType.RESIZE, true);
wordart.setLockedProperty(ShapeLockType.TEXT, true);

// Save the watermarked Excel file
workbook.save("output.xlsx");

Source: gist.githubusercontent.com

Similar codes

4 votes357 views1 answer
Java length of matrix
Java
0 vote337 views1 answer
Le but de ce sujet est d´écrire un programme JAVA pour aider à la gestion de la billeterie des différentes salles d'un complexe cinématographique. Les places non numérotées sont vendues selon deux tarif
Java
11 votes310 views3 answers
Iterate enum java
Java
1 vote333 views2 answers
How to convert epoch time to date in java
Java
0 vote371 views1 answer
Java final modifier on method
Java
2 votes368 views2 answers
How to find out if a directory exists in cpp
Java
0 vote349 views1 answer
Create and populate list one line java
Java
1 vote375 views1 answer
How to connect java class file to xml file
Java
2 votes337 views2 answers
Java append a string to file
Java
6 votes407 views2 answers
Java save file
Java