AddWordArtWatermarkToChart.java

package com.aspose.cells.examples.asposefeatures.charts;

import com.aspose.cells.MsoPresetTextEffect;
import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
import com.aspose.cells.examples.Utils;

public class AddWordArtWatermarkToChart
{
    public static void main(String[] args) throws Exception
    {
        // The path to the documents directory.
        String dataDir = Utils.getDataDir(AddWordArtWatermarkToChart.class);

        //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.
        com.aspose.cells.MsoFillFormat wordArtFormat = wordart.getFillFormat();

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

        //Get the line format and make it invisible.
        com.aspose.cells.MsoLineFormat lineFormat = wordart.getLineFormat();
        lineFormat.setVisible(false);

        //Save the excel file.
        workbook.save(dataDir + "AsposeChartWatermarked_Out.xls", SaveFormat.EXCEL_97_TO_2003);

        System.out.println("Chart is watermarked now.");
    }
}