/// <summary>
/// 在sheet中添加水印
/// </summary>
/// <param name="worksheet"></param>
/// <param name="effect"></param>
/// <param name="text"></param>
/// <param name="fontName"></param>
/// <param name="size"></param>
/// <param name="fontBold"></param>
/// <param name="fontItalic"></param>
/// <param name="upperLeftRow"></param>
/// <param name="top"></param>
/// <param name="upperLeftColumn"></param>
/// <param name="left"></param>
/// <param name="height"></param>
/// <param name="width"></param>
static void AddWaterMarkInSheet(Worksheet worksheet, MsoPresetTextEffect effect, string text,
string fontName, int size, bool fontBold, bool fontItalic, int upperLeftRow,
int top, int upperLeftColumn, int left, int height, int width)
{
Aspose.Cells.Drawing.Shape wordart = worksheet.Shapes.AddTextEffect(
effect, text, fontName, size, fontBold, fontItalic, upperLeftRow, top, upperLeftColumn, left, height, width);
MsoFillFormat wordArtFormat = wordart.FillFormat;
wordArtFormat.ForeColor = System.Drawing.Color.Red;
wordArtFormat.Transparency = 0.9;
MsoLineFormat lineFormat = wordart.LineFormat;
lineFormat.IsVisible = false;
wordart.SetLockedProperty(ShapeLockType.Selection, true);
wordart.SetLockedProperty(ShapeLockType.ShapeType, true);
wordart.SetLockedProperty(ShapeLockType.Move, true);
wordart.SetLockedProperty(ShapeLockType.Resize, true);
wordart.SetLockedProperty(ShapeLockType.Text, true);
}
static void Main(string[] args)
{
string FilePath = @"..\..\..\Sample Files\";
string FileName = FilePath + "Locking WordArt Watermark.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);
//Lock Shape Aspects
wordart.IsLocked = true;
wordart.SetLockedProperty(ShapeLockType.Selection, true);
wordart.SetLockedProperty(ShapeLockType.ShapeType, true);
wordart.SetLockedProperty(ShapeLockType.Move, true);
wordart.SetLockedProperty(ShapeLockType.Resize, true);
wordart.SetLockedProperty(ShapeLockType.Text, true);
//Get the fill format of the word art
MsoFillFormat wordArtFormat = wordart.FillFormat;
//Set the color
wordArtFormat.ForeColor = 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);
}