usmanazizgroupdocs
4/17/2017 - 9:33 AM

Documents-RemoveWatermarkExcelWorksheet.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 search criteria
    Dim imageSearchCriteria As ImageSearchCriteria = New ImageDctHashSearchCriteria("D:\logo.png")
    Dim textSearchCriteria As New TextSearchCriteria("Company Name")

    ' Call FindWatermarks method for the worksheet
    Dim possibleWatermarks As PossibleWatermarkCollection = doc.Worksheets(0).FindWatermarks(textSearchCriteria.[Or](imageSearchCriteria))

    ' Remove all found watermarks
    For i As Object = possibleWatermarks.Count - 1 To 0 Step -1
        possibleWatermarks.RemoveAt(i)
    Next

    doc.Save()
End Using