ExcelFormulaParser.Engine.ExcelUtilities.RangeAddressFactory.Create C# (CSharp) Method

Create() public method

public Create ( string range ) : RangeAddress
range string
return RangeAddress
        public RangeAddress Create(string range)
        {
            Require.That(range).Named("range").IsNotNullOrEmpty();
            var addressInfo = ExcelAddressInfo.Parse(range);
            var rangeAddress = new RangeAddress()
            {
                Address = range,
                Worksheet = addressInfo.Worksheet
            };

            if (addressInfo.IsMultipleCells)
            {
                HandleMultipleCellAddress(rangeAddress, addressInfo);
            }
            else
            {
                HandleSingleCellAddress(rangeAddress, addressInfo);
            }
            return rangeAddress;
        }

Same methods

RangeAddressFactory::Create ( int col, int row ) : RangeAddress

Usage Example

Ejemplo n.º 1
0
 public void ColumnShouldReturnRowFromCurrentScopeIfNoAddressIsSupplied()
 {
     var func = new Column();
     var parsingContext = ParsingContext.Create();
     var rangeAddressFactory = new RangeAddressFactory(MockRepository.GenerateStub<ExcelDataProvider>());
     parsingContext.Scopes.NewScope(rangeAddressFactory.Create("B2"));
     var result = func.Execute(Enumerable.Empty<FunctionArgument>(), parsingContext);
     Assert.AreEqual(2, result.Result);
 }
All Usage Examples Of ExcelFormulaParser.Engine.ExcelUtilities.RangeAddressFactory::Create