Add WordArt Watermark to Worksheet

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.

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

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
    System.IO.Directory.CreateDirectory(dataDir);

// 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 word art
FillFormat wordArtFormat = wordart.Fill;            

// Set the transparency
wordArtFormat.Transparency = 0.9;

// Make the line invisible
LineFormat lineFormat = wordart.Line;          

dataDir = dataDir + "Watermark_Test.out.xls";
// Save the file
workbook.Save(dataDir);

Advance topics

• Add Word Art Text with Built-in Styles
• Locking WordArt Watermark
• Set preset WordArt style to the text of the shape