Skip to main content

Dynamic-Arrays

Testing for whether the running Excel instance supports dynamic arrays​

        static bool? _supportsDynamicArrays;  
        [ExcelFunction(IsHidden=true)]
        public static bool SupportsDynamicArrays()
        {
            if (!_supportsDynamicArrays.HasValue)
            {
                try
                {
                    var result = XlCall.Excel(614, new object[] { 1 }, new object[] { true });
                    _supportsDynamicArrays = true;
                }
                catch
                {
                    _supportsDynamicArrays = false;
                }
            }
            return _supportsDynamicArrays.Value;
        }