Working with spreadsheet document attachments Leave feedback

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetWorksheet worksheet in content.Worksheets)
    {
        foreach (SpreadsheetAttachment attachment in worksheet.Attachments)
        {
            Console.WriteLine("Alternative text: {0}", attachment.AlternativeText);
            Console.WriteLine("Attachment frame x-coordinate: {0}", attachment.X);
            Console.WriteLine("Attachment frame y-coordinate: {0}", attachment.Y);
            Console.WriteLine("Attachment frame width: {0}", attachment.Width);
            Console.WriteLine("Attachment frame height: {0}", attachment.Height);
            Console.WriteLine("Preview image size: {0}", attachment.PreviewImageContent != null 
                ? attachment.PreviewImageContent.Length : 0);
            if (attachment.IsLink)
            {
                // The document contains only a link to the attached file
                Console.WriteLine("Full path to the attached file: {0}", attachment.SourceFullName);
            }
            else
            {
                // The attached file is stored in the document
                Console.WriteLine("File type: {0}", attachment.GetDocumentInfo().FileType);
                Console.WriteLine("Name of the source file: {0}", attachment.SourceFullName);
                Console.WriteLine("File size: {0}", attachment.Content.Length);
            }
        }
    }

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    SpreadsheetWorksheet worksheet = content.Worksheets[0];
    // Add the attachment
    worksheet.Attachments.AddAttachment(File.ReadAllBytes("document.docx"), // File content
        "sample document.docx", // Source file full name (the extension is used
        // to determine appropriate application to open
        // the file) 
        File.ReadAllBytes("document_preview.png"), // Preview image content
        50, // X-coordinate of the attachment frame
        100, // Y-coordinate of the attachment frame
        200, // Attachment frame width
        400); // Attachment frame height

    // Save changes
    watermarker.Save("spreadsheet.xlsx");
}

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    SpreadsheetWorksheet worksheet = content.Worksheets[0];

    // Add the attachment
    worksheet.Attachments.AddLink("document.docx", // Source file path
        File.ReadAllBytes("document_preview.png"), // Preview image content
        50, // X-coordinate of the attachment frame
        100, // Y-coordinate of the attachment frame
        200, // Attachment frame width
        400); // Attachment frame height
        
    // Save changes
    watermarker.Save("spreadsheet.xlsx");
}

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetWorksheet worksheet in content.Worksheets)
    {
        for (int i = worksheet.Attachments.Count - 1; i >= 0; i--)
        {
            SpreadsheetAttachment attachment = worksheet.Attachments[i];
            if (attachment.IsLink &&
                !File.Exists(attachment.SourceFullName) || // Linked file that is not available at this moment
                attachment.GetDocumentInfo().IsEncrypted) // Attached file protected with a password
            {
                // Remove the file if it meets at least one of the conditions above
                worksheet.Attachments.RemoveAt(i);
            }
        }
    }

    // Save changes
    watermarker.Save("spreadsheet.xlsx");
}

TextWatermark watermark = new TextWatermark("Test watermark", new Font("Arial", 19));
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetWorksheet worksheet in content.Worksheets)
    {
        foreach (SpreadsheetAttachment attachment in worksheet.Attachments)
        {
            // Check if the attached file is supported by GroupDocs.Watermark
            IDocumentInfo info = attachment.GetDocumentInfo();
            if (info.FileType != FileType.Unknown && !info.IsEncrypted)
            {
                // Load the attached document
                using (Watermarker attachedWatermarker = attachment.CreateWatermarker())
                {
                    // Add wateramrk
                    attachedWatermarker.Add(watermark);

                    // Save changes in the attached file
                    attachedWatermarker.Save();
                }
            }
        }
    }

    // Save changes
    watermarker.Save("spreadsheet.xlsx");
}

// Consider only the attached images
WatermarkerSettings settings = new WatermarkerSettings();
settings.SearchableObjects.SpreadsheetSearchableObjects = SpreadsheetSearchableObjects.AttachedImages;

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions, settings))
{
    // Specify sample image to compare document images with
    ImageSearchCriteria criteria = new ImageDctHashSearchCriteria("attachment.png");

    // Search for similar images
    PossibleWatermarkCollection possibleWatermarks = watermarker.Search(criteria);

    // Remove or modify found image watermarks
    // ...

    Console.WriteLine("Found {0} possible watermark(s).", possibleWatermarks.Count);
}