ExternalCellValue.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;
 
namespace NanoXLSX
{
    public class ExternalCellValue
    {
        public enum DataType
        {
            Number,
            Boolean,
            Date,
            Error,
#pragma warning disable CA1720
            String,
#pragma warning restore CA1720
            Empty
        }

        public string Value { get; private set; }
 
        public DataType Type { get; private set; }

        internal int? CellMetadata { get; set; }

        public ExternalCellValue(string value, DataType type)
        {
            if (value == null || type == DataType.Empty)
            {
                Value = "";
                Type = DataType.Empty;
                return;
            }
 
            Value = NormalizeValue(value, type);
            Type = type;
        }

        public ExternalCellValue(string value) : this(value, DataType.String) { }

        private static string NormalizeValue(string value, DataType type)
        {
            switch (type)
            {
                case DataType.Boolean:
                    if (value == "1" || value.Equals("true", StringComparison.OrdinalIgnoreCase))
                    {
                        return "1";
                    }
                    if (value == "0" || value.Equals("false", StringComparison.OrdinalIgnoreCase))
                    {
                        return "0";
                    }
                    throw new ArgumentException("An invalid boolean value was provided (0 or 1 are expected): " + value);
                default:
                    return value;
            }
        }
    }
}