public void Initialize() { _excelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); _excelDataProvider.Stub(x => x.GetDimensionEnd(Arg<string>.Is.Anything)).Return(new ExcelCellAddress(10, 1)); _parser = new FormulaParser(_excelDataProvider); _package = new ExcelPackage(); _worksheet = _package.Workbook.Worksheets.Add("Test"); }
public void ParseAtShouldCallExcelDataProvider() { var excelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); excelDataProvider .Stub(x => x.GetRangeFormula(string.Empty, 1, 1)) .Return("Sum(1,2)"); var parser = new FormulaParser(excelDataProvider); var result = parser.ParseAt("A1"); Assert.AreEqual(3d, result); }
public void Dispose() { _sharedStrings.Clear(); _sharedStringsList.Clear(); _sharedStrings = null; _sharedStringsList = null; _vba = null; if (_worksheets != null) { _worksheets.Dispose(); _worksheets = null; } _package = null; _properties = null; if (_formulaParser != null) { _formulaParser.Dispose(); _formulaParser = null; } }
internal FormulaParserManager(FormulaParser parser) { Require.That(parser).Named("parser").IsNotNull(); _parser = parser; }
public void Setup() { var excelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); _parser = new FormulaParser(excelDataProvider); }
private static void CalcChain(ExcelWorkbook wb, FormulaParser parser, DependencyChain dc) { foreach (var ix in dc.CalcOrder) { var item = dc.list[ix]; try { var ws = wb.Worksheets.GetBySheetID(item.SheetID); var v = parser.ParseCell(item.Tokens, ws == null ? "" : ws.Name, item.Row, item.Column); SetValue(wb, item, v); } catch (FormatException fe) { throw (fe); } catch// (Exception e) { var error = ExcelErrorValue.Parse(ExcelErrorValue.Values.Value); SetValue(wb, item, error); } } }