如何删除 Excel 文档中具有特殊格式的文本水印。
C#
// 加载 Excel 工作簿
var loadOptions = new SpreadsheetLoadOptions();
using (Watermarker watermarker = new Watermarker("source.xlsx", loadOptions))
{
// 获取内容并找到相应的水印
SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
foreach (SpreadsheetWorksheet section in content.Worksheets)
{
for (int i = section.Shapes.Count - 1; i >= 0; i--)
{
foreach (FormattedTextFragment fragment in section.Shapes[i].FormattedTextFragments)
{
if (fragment.ForegroundColor.Equals(Color.Red) && fragment.Font.FamilyName == "Arial")
{
// 移除文字水印
section.Shapes.RemoveAt(i);
break;
}
}
}
}
// 保存已处理 XLSX
watermarker.save("result.xlsx");
}