ReaderOptions.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 © 2025
 * 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.Collections.Generic;
using System.Globalization;
using NanoXLSX.Exceptions;
using NanoXLSX.Interfaces.Plugin;
 
namespace NanoXLSX
{
    public class ReaderOptions : IOptions
    {

        public const string DefaultDateTimeFormat = "yyyy-MM-dd HH:mm:ss";

        public const string DefaultTimeSpanFormat = "hh\\:mm\\:ss";

        public static readonly CultureInfo DefaultCultureInfo = CultureInfo.InvariantCulture;

        public enum GlobalType
        {
            Default,
            AllNumbersToDouble,
            AllNumbersToDecimal,
            AllNumbersToInt,
            EverythingToString
        }

        public enum ColumnType
        {
#pragma warning disable CA1720 // Identifier contains type name
            Numeric,
            Double,
            Decimal,
            Date,
            Time,
            Bool,
            String
#pragma warning restore CA1720 // Identifier contains type name
        }

        public bool EnforceDateTimesAsNumbers { get; set; }

        public bool EnforcePhoneticCharacterImport { get; set; }

        public bool EnforceEmptyValuesAsString { get; set; }

        public bool EnforceStrictValidation { get; set; }

        public GlobalType GlobalEnforcingType { get; set; } = GlobalType.Default;
 

        public Dictionary<int, ColumnType> EnforcedColumnTypes { get; private set; } = new Dictionary<int, ColumnType>();

        public int EnforcingStartRowNumber { get; set; }

        public string DateTimeFormat { get; set; } = DefaultDateTimeFormat;

        public string TimeSpanFormat { get; set; } = DefaultTimeSpanFormat;

        public CultureInfo TemporalCultureInfo { get; set; } = DefaultCultureInfo;

        public bool IgnoreNotSupportedPasswordAlgorithms { get; set; }

        public void AddEnforcedColumn(string columnAddress, ColumnType type)
        {
            this.EnforcedColumnTypes.Add(Cell.ResolveColumn(columnAddress), type);
        }

        public void AddEnforcedColumn(int columnNumber, ColumnType type)
        {
            this.EnforcedColumnTypes.Add(columnNumber, type);
        }
    }
}