ExternalWorksheet.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.Utils;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using static NanoXLSX.ExternalCellValue;
 
namespace NanoXLSX
{
    public class ExternalWorksheet
    {

        private readonly Dictionary<Address, ExternalCellValue> cells = new Dictionary<Address, ExternalCellValue>();
 

        public ReadOnlyDictionary<Address, ExternalCellValue> Cells
        {
            get { return new ReadOnlyDictionary<Address, ExternalCellValue>(cells); }
        }

        public string Name { get; }

        internal bool? RefreshErros { get; set; }

        public ExternalWorksheet(string name)
        {
            Validators.ValidateWorksheetName(name);
            Name = name;
        }

        public ExternalWorksheet AddCell(string address, string value)
        {
            return AddCell(address, value, ExternalCellValue.DataType.String);
        }

        public ExternalWorksheet AddCell(string address, string value, ExternalCellValue.DataType type)
        {
            Validators.ValidateCellAddressExpression(address, Cell.AddressScope.SingleAddress);
            cells[new Address(address)] = new ExternalCellValue(value, type);
            return this;
 
        }

        internal void AddCell(string address, string value, ExternalCellValue.DataType type, string cellMetaData)
        {
            AddCell(address, value, type);
            if (cellMetaData != null)
            {
                cells[new Address(address)].CellMetadata = ParserUtils.ParseInt(cellMetaData);
            }
        }

        public bool RemoveCell(string address)
        {
            Validators.ValidateCellAddressExpression(address, Cell.AddressScope.SingleAddress);
            return cells.Remove(new Address(address));
        }

        public bool TryGetCell(string address, out ExternalCellValue cell)
        {
            try
            {
                return cells.TryGetValue(new Address(address), out cell);
            }
            catch (Exception)
            {
                cell = null;
                return false;
            }
        }
    }
}