以下代码展示了如何在Excel电子表格中更改水印文本。
Python
# 打开XLSX文件
import groupdocs.watermark as gw
import groupdocs.watermark.watermarks as gww
import groupdocs.watermark.search.searchcriteria as gwss
import groupdocs.watermark.options.spreadsheet as gwos
# 读取电子表格数据
with gw.Watermarker("source.xlsx") as watermarker:
search_criteria = gwss.TextSearchCriteria("test", False)
search_criteria.pages = [1,3]
# 更改水印文本
watermarks = watermarker.search(search_criteria)
for watermark in watermarks:
try:
watermark.formatted_text_fragments.clear()
watermark.formatted_text_fragments.add(
"passed",
gww.Font("Calibri", 19.0, gww.FontStyle.bold),
gww.Color.red,
gww.Color.aqua
)
except Exception as e:
pass
# 保存结果
watermarker.save("output.xlsx")