Add watermarks to spreadsheet documents Leave feedback
On this page
Open a spreadsheet with SpreadsheetLoadOptions and pass a spreadsheet-specific watermark option to add() to target a particular worksheet, a background, or a header/footer.
Use SpreadsheetWatermarkShapeOptions and set worksheet_index to add the watermark as a shape on a specific worksheet.
from groupdocs.watermark import Watermarker
from groupdocs.watermark.watermarks import TextWatermark, Font, Color
from groupdocs.watermark.common import HorizontalAlignment, VerticalAlignment
from groupdocs.watermark.options.spreadsheet import (
SpreadsheetLoadOptions, SpreadsheetWatermarkShapeOptions,
)
def add_watermark_to_worksheet():
with Watermarker("./spreadsheet.xlsx", SpreadsheetLoadOptions()) as watermarker:
watermark = TextWatermark("CONFIDENTIAL", Font("Arial", 19.0))
watermark.foreground_color = Color.red
watermark.horizontal_alignment = HorizontalAlignment.CENTER
watermark.vertical_alignment = VerticalAlignment.CENTER
options = SpreadsheetWatermarkShapeOptions()
options.worksheet_index = 0
watermarker.add(watermark, options)
watermarker.save("./output.xlsx")
if __name__ == "__main__":
add_watermark_to_worksheet()
spreadsheet.xlsx is the sample file used in this example. Click here to download it.
Binary file (XLSX, 48 KB)
Other worksheet placements are available through dedicated options — SpreadsheetBackgroundWatermarkOptions (worksheet background) and SpreadsheetWatermarkHeaderFooterOptions (header/footer). Watermarker.get_content() returns a SpreadsheetContent exposing each worksheet’s shapes, charts, backgrounds, headers/footers, and attachments.
For the full set of spreadsheet content operations, see the dedicated topics:
- Shapes in spreadsheet document
- Working with spreadsheet document attachments
- Working with worksheet backgrounds
- Working with worksheet headers and footers
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
