usmanazizgroupdocs
4/17/2017 - 9:52 AM

Documents-AddWatermarkToImagesInHeaderFooterExcel.vb

' For complete examples and data files, please go to https://github.com/groupdocs-watermark/GroupDocs.Watermark-for-.NET
Using doc As CellsDocument = Document.Load(Of CellsDocument)(Utilities.MapSourceFilePath(FilePath))
    ' Initialize image or text watermark
    Dim watermark As New TextWatermark("Protected image", New Font("Arial", 8))
    watermark.HorizontalAlignment = HorizontalAlignment.Center
    watermark.VerticalAlignment = VerticalAlignment.Center
    watermark.RotateAngle = 45
    watermark.SizingType = SizingType.ScaleToParentDimensions
    watermark.ScaleFactor = 1

    For Each worksheet As CellsWorksheet In doc.Worksheets
        For Each headerFooter As CellsHeaderFooter In worksheet.HeadersFooters
            For Each section As CellsHeaderFooterSection In headerFooter.Sections
                If section.Image IsNot Nothing Then
                    ' Add watermark to the image
                    section.Image.AddWatermark(watermark)
                End If
            Next
        Next
    Next
End Using