Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Use WordArt to add special text effects to spreadsheets. For example, stretch a title across the top of the file, decorate text, and 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");
Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.