usmanazizgroupdocs
4/17/2017 - 9:09 AM

RemoveWatermarkExcelWorksheet.cs

// For complete examples and data files, please go to https://github.com/groupdocs-watermark/GroupDocs.Watermark-for-.NET
using (CellsDocument doc = Document.Load<CellsDocument>(Utilities.MapSourceFilePath (FilePath)))
{
    // Initialize search criteria
    ImageSearchCriteria imageSearchCriteria = new ImageDctHashSearchCriteria(@"D:\logo.png");
    TextSearchCriteria textSearchCriteria = new TextSearchCriteria("Company Name");

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

    // Remove all found watermarks
    for (var i = possibleWatermarks.Count - 1; i >= 0; i--)
    {
        possibleWatermarks.RemoveAt(i);
    }

    doc.Save();
}