原創(chuàng)|其它|編輯:郝浩|2012-11-13 17:32:50.000|閱讀 980 次
概述:可以使用Aspose.Cells為電子表格添加特殊的文字效果。例如,可以拉伸標(biāo)題,修飾文本,并使文本符合預(yù)設(shè)形狀,或者是為電子表格添加水印效果。
# 界面/圖表報(bào)表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
可以使用Aspose.Cells為電子表格添加特殊的文字效果。例如,可以拉伸標(biāo)題,修飾文本,并使文本符合預(yù)設(shè)形狀,或者是為電子表格添加水印效果。
在下面的例子中將演示如何使用Aspose.Cells提供的簡(jiǎn)單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")
本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請(qǐng)務(wù)必注明出處、不得修改原文相關(guān)鏈接,如果存在內(nèi)容上的異議請(qǐng)郵件反饋至chenjj@fc6vip.cn
文章轉(zhuǎn)載自:慧都控件網(wǎng)