如何在Excel工作表中添加水印
Contents
[
Hide
]
使用WordArt向电子表格添加特殊文本或图片效果。例如,将标题延伸到文件顶部、装饰文本、使文本适应预设形状,或将文本作为背景水印应用到Excel表中。WordArt变成一个对象,您可以在电子表格中移动或定位以添加装饰。
以下示例演示了如何将文本作为WordArt添加到工作表以设置背景水印。
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
Aspose::Cells::Startup(); | |
// Instantiate a new Workbook | |
Workbook wb; | |
// Get the first worksheet | |
WorksheetCollection wsc = wb.GetWorksheets(); | |
Worksheet ws = wsc.Get(0); | |
// Add Text Watermark | |
Shape wordart = ws.GetShapes().AddTextEffect(MsoPresetTextEffect::TextEffect1, | |
u"CONFIDENTIAL", u"Arial Black", 50, false, true | |
, 18, 8, 1, 1, 130, 800); | |
// Get the fill format of the word art | |
FillFormat wordArtFormat = wordart.GetFill(); | |
// Set the transparency | |
wordArtFormat.SetTransparency(0.9); | |
// Save the file | |
wb.Save(u"Watermark_Text.xlsx"); | |
Aspose::Cells::Cleanup(); |
The following example shows how to add a picture as WordArt to set a background watermark for a worksheet. 源文件
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
Aspose::Cells::Startup(); | |
//Path of input | |
U16String dirPath(u""); | |
//Path of output | |
U16String outPath(u""); | |
// Instantiate a new Workbook | |
Workbook wb; | |
// Get the first worksheet | |
WorksheetCollection wsc = wb.GetWorksheets(); | |
Worksheet ws = wsc.Get(0); | |
// open a file | |
std::ifstream fileStream(dirPath.ToUtf8() + "watermark.png", std::ios::binary); | |
if (!fileStream.is_open()) { | |
std::cerr << "Failed to open the file." << std::endl; | |
return 1; | |
} | |
// Get file size | |
fileStream.seekg(0, std::ios::end); | |
std::streampos fileSize = fileStream.tellg(); | |
fileStream.seekg(0, std::ios::beg); | |
// Read file contents into uint8_t array | |
uint8_t* buffer = new uint8_t[fileSize]; | |
fileStream.read(reinterpret_cast<char*>(buffer), fileSize); | |
fileStream.close(); | |
Vector<uint8_t>data(buffer, fileSize); | |
delete[] buffer; | |
// Set a picture as the Watermark. | |
ws.SetBackgroundImage(data); | |
// Save the file | |
wb.Save(outPath + u"Watermark_Pict.xlsx"); | |
Aspose::Cells::Cleanup(); |