Add Word Art Watermark to Chart

Aspose.Cells - Add Word Art Watermark to Chart

You can use WordArt to add special text effects to spreadsheets. For example, stretch a title, decorate text, make text fit a preset shape, or apply the text as a watermark to a chart’s plot area. The WordArt becomes an object that you can move or position in your spreadsheets to add decoration.

Java

  

 // Instantiate a new workbook.  

 // Open the existing Excel file.  

Workbook workbook = new Workbook(dataDir + "AsposeChart.xls");  

 // Get the chart in the first worksheet.  

com.aspose.cells.Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);  

 // Add a WordArt watermark (shape) to the chart's plot area.  

com.aspose.cells.Shape wordart = chart.getShapes().addTextEffectInChart(MsoPresetTextEffect.TEXT_EFFECT_2,  

"CONFIDENTIAL", "Arial Black", 66, false, false, 1200, 500, 2000, 3000);  

 // 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 Excel file.  

workbook.save(dataDir + "AsposeChartWatermarked_Out.xls", SaveFormat.EXCEL_97_TO_2003);  

Download Running Code

Download Sample Code