可以使用Aspose.Cells为电子表格添加特殊的文字效果。例如,可以拉伸标题,修饰文本,并使文本符合预设形状,或者是为电子表格添加水印效果。
在下面的例子中将演示如何使用Aspose.Cells提供的简单API为工作表添加水印效果。
示例代码：
C#
//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
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("e:\\test2\\Watermarkt_Test.xls");
[VB]
'Instantiate a new Workbook
Dim workbook As New Workbook()
'Get the first default sheet
Dim sheet As Worksheet = workbook.Worksheets(0)
'Add Watermark
Dim wordart As Aspose.Cells.Drawing.Shape = 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
Dim wordArtFormat As MsoFillFormat = wordart.FillFormat
'Set the color
wordArtFormat.ForeColor = System.Drawing.Color.Red
'Set the transparency
wordArtFormat.Transparency = 0.9
'Make the line invisible
Dim lineFormat As MsoLineFormat = wordart.LineFormat
lineFormat.IsVisible = False
'Save the file
workbook.Save("e:\test2\Watermarkt_Test.xls")