Add WordArt Watermark to Worksheet in Aspose.Cells

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.

The following example shows how to add a WordArt shape to set a background watermark for a worksheet.

After running the code, the output file contains a pale red WordArt watermark.

The output file

C#

string FilePath = @"..\..\..\Sample Files\";
string FileName = FilePath + "Add WordArt Watermark to Worksheet.xlsx";

// Instantiate a new Workbook
Workbook workbook = new Workbook();

// Get the first default sheet
Worksheet sheet = workbook.Worksheets[0];

// Add Watermark
Aspose.Cells.Drawing.Shape wordart = sheet.Shapes.AddTextEffect(
    MsoPresetTextEffect.TextEffect1,
    "CONFIDENTIAL",
    "Arial Black",
    50,
    false,
    true,
    18,
    8,
    1,
    1,
    130,
    800);

// Get the fill format of the WordArt
MsoFillFormat wordArtFormat = wordart.FillFormat;

// Set the color
wordArtFormat.ForeColor = System.Drawing.Color.Red;

// Set the transparency
wordArtFormat.Transparency = 0.9;

// Make the line invisible
MsoLineFormat lineFormat = wordart.LineFormat;
lineFormat.IsVisible = false;

// Save the file
workbook.Save(FileName);

Download Sample Code

• GitHub

Download Running Example

• GitHub