WorkbookExtensions.cs

/*
 * NanoXLSX is a small .NET library to generate and read XLSX (Microsoft Excel 2007 or newer) files in an easy and native way  
 * Copyright Raphael Stoeckli © 2026
 * This library is licensed under the MIT License.
 * You find a copy of the license in project folder or on: http://opensource.org/licenses/MIT
 */
 
using NanoXLSX.Internal;
using NanoXLSX.Registry;
using System;
using System.Collections.Generic;
using System.ComponentModel;
 
namespace NanoXLSX.Extensions
{
    [EditorBrowsable(EditorBrowsableState.Never)]
    public static class WorkbookExtensions
    {
        public static void AddExternalLink(this Workbook workbook, ExternalLink externalLink)
        {
            if (externalLink == null)
            {
                throw new ArgumentNullException(nameof(externalLink), "An external link cannot be null.");
            }
            IReadOnlyList<ExternalLink> externalLinks = GetExternalLinks(workbook);
            int index = externalLinks.Count;
            while (workbook.AuxiliaryData.GetData<ExternalLink>(PlugInUUID.CompatibilityInlineProcessor, CompatibilityConstants.EXTERNAL_LINK_OBJECT_ENTITY, index) != null)
            {
                index++;
            }
            workbook.AuxiliaryData.SetData(PlugInUUID.CompatibilityInlineProcessor, CompatibilityConstants.EXTERNAL_LINK_OBJECT_ENTITY, index, externalLink, true);
        }

        public static ExternalLink AddExternalLink(this Workbook workbook, ExternalLinkBuilder builder)
        {
            if (builder == null)
            {
                throw new ArgumentNullException(nameof(builder), "A builder for external link cannot be null.");
            }
            ExternalLink externalLink = builder.Build();
            AddExternalLink(workbook, externalLink);
            return externalLink;
        }

        public static IReadOnlyList<ExternalLink> GetExternalLinks(this Workbook workbook)
        {
            return workbook.AuxiliaryData.GetDataList<ExternalLink>(PlugInUUID.CompatibilityInlineProcessor, CompatibilityConstants.EXTERNAL_LINK_OBJECT_ENTITY);
        }

        public static bool RemoveExternalLink(this Workbook workbook, ExternalLink externalLink)
        {
            return workbook.AuxiliaryData.RemoveEntityData(PlugInUUID.CompatibilityInlineProcessor, CompatibilityConstants.EXTERNAL_LINK_OBJECT_ENTITY, externalLink);
        }

        public static void ClearExternalLinks(this Workbook workbook)
        {
            workbook.AuxiliaryData.ClearEntityData(PlugInUUID.CompatibilityInlineProcessor, CompatibilityConstants.EXTERNAL_LINK_OBJECT_ENTITY);
        }
 
    }
}