Add Word Art Watermark to Worksheet using Aspose.Cells

Aspose.Cells - Add Word Art Watermark to Worksheet

Use WordArt to add special text effects to spreadsheets. For example, stretch a title across the top of the sheet, decorate text, make text fit a preset shape, or apply text to an Excel sheet as a background watermark. The WordArt becomes an object that you can move or position in spreadsheets to add decoration.

Java

 Workbook workbook = new Workbook();

//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 shape's fill format
FillFormat wordArtFormat = wordart.getFill();

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

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

//Save the file
workbook.save(dataDir + "AsposeWatermark_Out.xls");

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Add WordArt Watermark to Worksheet.