Add() public method

public Add ( CalculationCell cell ) : void
cell CalculationCell
return void
Beispiel #1
0
        public virtual CalculationChain Build(string worksheetName)
        {
            var graphs = new DependencyGraphs();

            if (string.IsNullOrEmpty(worksheetName))
            {
                return(new CalculationChain());
            }
            var lexer = _parsingContext.Configuration.Lexer;
            var cells = string.IsNullOrEmpty(worksheetName) ?
                        _parsingContext.ExcelDataProvider.GetWorkbookFormulas() :
                        _parsingContext.ExcelDataProvider.GetWorksheetFormulas(worksheetName);
            var  sw = new Stopwatch();
            long part1 = 0, part2 = 0;

            foreach (var formulaCell in cells)
            {
                sw.Start();
                var currentCell = formulaCell.Key;
                var formula     = formulaCell.Value;
                var r           = lexer.Tokenize(formula);
                var toAddresses = r.Where(x => x.TokenType == TokenType.ExcelAddress);
                sw.Stop();
                part1 += sw.ElapsedMilliseconds;
                sw.Reset();
                sw.Start();
                foreach (var address in toAddresses)
                {
                    if (cells.ContainsKey(address.Value))
                    {
                        graphs.Add(currentCell, address.Value);
                    }
                }
                sw.Stop();
                part2 += sw.ElapsedMilliseconds;
                sw.Reset();
            }
            var calcChain = new CalculationChain();

            foreach (var graph in graphs.GetGraphs())
            {
                foreach (var formula in graph.OrderedFormulas)
                {
                    calcChain.Add(new CalculationCell {
                        Address = formula
                    });
                }
            }
            return(calcChain);
        }
 public virtual CalculationChain Build(string worksheetName)
 {
     var graphs = new DependencyGraphs();
     if (string.IsNullOrEmpty(worksheetName))
     {
         return new CalculationChain();
     }
     var lexer = _parsingContext.Configuration.Lexer;
     var cells = string.IsNullOrEmpty(worksheetName) ?
         _parsingContext.ExcelDataProvider.GetWorkbookFormulas() :
         _parsingContext.ExcelDataProvider.GetWorksheetFormulas(worksheetName);
     var sw = new Stopwatch();
     long part1 = 0, part2 = 0;
     foreach (var formulaCell in cells)
     {
         sw.Start();
         var currentCell = formulaCell.Key;
         var formula = formulaCell.Value;
         var r = lexer.Tokenize(formula);
         var toAddresses = r.Where(x => x.TokenType == TokenType.ExcelAddress);
         sw.Stop();
         part1 += sw.ElapsedMilliseconds;
         sw.Reset();
         sw.Start();
         foreach (var address in toAddresses)
         {
             if (cells.ContainsKey(address.Value))
             {
                 graphs.Add(currentCell, address.Value);
             }
         }
         sw.Stop();
         part2 += sw.ElapsedMilliseconds;
         sw.Reset();
     }
     var calcChain = new CalculationChain();
     foreach (var graph in graphs.GetGraphs())
     {
         foreach (var formula in graph.OrderedFormulas)
         {
             calcChain.Add(new CalculationCell { Address = formula });
         }
     }
     return calcChain;
 }