ExternalLinkBuilder.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 System;
using static NanoXLSX.ExternalCellValue;
 
namespace NanoXLSX
{
    public class ExternalLinkBuilder
    {
        private readonly ExternalLink externalLink;
        private ExternalWorksheet currentWorksheet;

        public ExternalLinkBuilder(string absoluteUri, string relativeUri = null)
        {
            ExternalLink externalLink = new ExternalLink(absoluteUri, relativeUri);
            this.externalLink = externalLink;
        }

        internal ExternalLinkBuilder(ExternalLink externalLink)
        {
            this.externalLink = externalLink ?? throw new ArgumentException("The external link cannot be null");
        }

        public ExternalLink Build()
        {
            return externalLink;
        }

        public ExternalLinkBuilder AddWorksheet(string name)
        {
            ExternalWorksheet worksheet = new ExternalWorksheet(name);
 
            externalLink.AddWorksheet(worksheet);
            currentWorksheet = worksheet;
 
            return this;
        }

        public ExternalLinkBuilder UseWorksheet(string name)
        {
            currentWorksheet = externalLink.GetWorksheet(name);
            return this;
        }

        public ExternalLinkBuilder AddCell(string address, string value)
        {
            EnsureCurrentWorksheet();
            currentWorksheet.AddCell(address, value);
 
            return this;
        }

        public ExternalLinkBuilder AddCell(string address, string value, ExternalCellValue.DataType type)
        {
            EnsureCurrentWorksheet();
            currentWorksheet.AddCell(address, value, type);
            return this;
        }

        private void EnsureCurrentWorksheet()
        {
            if (currentWorksheet == null)
            {
                throw new ArgumentException(
                    "No external worksheet is currently selected. " +
                    "Call AddWorksheet or UseWorksheet before adding cell data.");
            }
        }
 
    }
}