C# (CSharp) ExcelFormulaParser.Engine ExcelDataProvider.GetRangeValues示例

GetRangeValues() public abstract method

Returns values from the required range.

public abstract GetRangeValues ( string address ) : IEnumerable
address	string	An Excel address
return	IEnumerable

示例#1

文件： FormulaParser.cs 项目： guojianbin/ExcelFormulaParser

        public virtual object ParseAt(string address)
        {
            Require.That(address).Named("address").IsNotNullOrEmpty();
            var dataItem = _excelDataProvider.GetRangeValues(address).FirstOrDefault();

            if (dataItem == null || (dataItem.Value == null && dataItem.Formula == null))
            {
                return(null);
            }
            if (!string.IsNullOrEmpty(dataItem.Formula))
            {
                return(Parse(dataItem.Formula, _parsingContext.RangeAddressFactory.Create(address)));
            }
            return(Parse(dataItem.Value.ToString(), _parsingContext.RangeAddressFactory.Create(address)));
        }