将艺术字水印添加到工作表
Contents
[
Hide
]
使用艺术字为电子表格添加特殊文本效果。例如,在文件顶部拉伸标题、修饰文本并使文本适合预设形状,或将文本作为背景水印应用于 Excel 工作表。艺术字成为一个对象,您可以在电子表格中移动或定位以添加装饰。
下面的示例演示如何添加艺术字形状来为工作表设置背景水印。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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); |