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);
}
}
}
internal FormulaParserManager(FormulaParser parser)
{
Require.That(parser).Named("parser").IsNotNull();
_parser = parser;
}
