/// <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);
}
public XlShape AddTextEffect(MsoPresetTextEffect presetTextEffect, string text, string fontName, Single fontSize, MsoTriState fontBold, MsoTriState fontItalic, Single left, Single top)
{
object[] parameters = new object[8];
parameters[0] = presetTextEffect;
parameters[1] = text;
parameters[2] = fontName;
parameters[3] = fontSize;
parameters[4] = fontBold;
parameters[5] = fontItalic;
parameters[6] = left;
parameters[7] = top;
object returnValue = InstanceType.InvokeMember("AddTextEffect", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, parameters, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlShape newClass = new XlShape(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
/// <summary>创建艺术字对象。返回一个代表新艺术字对象的 Shape 对象。
/// 说明：
/// 向文档添加艺术字对象时，该对象的高度和宽度将自动根据所指定的文字的大小和数量来设置。
/// </summary>
/// <param name="PresetTextEffect">预置文字效果。</param>
/// <param name="Text">艺术字中的文字。</param>
/// <param name="FontName">艺术字中所用字体的名称。</param>
/// <param name="FontSize">艺术字中所用字体的大小（以磅为单位）。</param>
/// <param name="FontBold">在艺术字中要加粗的字体。</param>
/// <param name="FontItalic">在艺术字中要倾斜的字体。</param>
/// <param name="Left">艺术字边框左上角相对于文档左上角的位置（以磅为单位）。</param>
/// <param name="Top">艺术字边框左上角相对于文档顶部的位置（以磅为单位）。</param>
/// <returns></returns>
public Shape AddTextEffect(MsoPresetTextEffect PresetTextEffect, string Text, string FontName, double FontSize, MsoTriState FontBold, MsoTriState FontItalic, double Left, double Top)
{
_objaParameters = new object[8] { PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top };
object objShape = _objShapes.GetType().InvokeMember("AddTextEffect", BindingFlags.InvokeMethod, null, _objShapes, _objaParameters);
return new Shape(objShape);
}
