private static void ParseFormulas(EPPlusExcelDataProvider provider, FormulaParser parser, ExcelWorksheet worksheet)
{
var formulas = provider.GetWorksheetFormulas(worksheet.Name);
foreach (var formulaAddress in formulas.Keys)
{
var result = parser.ParseAt(formulaAddress);
provider.SetCellValue(formulaAddress, result);
}
}
public void ParseAtShouldCallExcelDataProvider()
{
var excelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>();
excelDataProvider
.Stub(x => x.GetRangeValues("A1"))
.Return(new List<ExcelCell> { new ExcelCell(null, "Sum(1,2)", 0, 0) });
var parser = new FormulaParser(excelDataProvider);
var result = parser.ParseAt("A1");
Assert.AreEqual(3d, result);
}
public void DefinedNameTest()
{
//lopment\ExcelFormulaParser\src\ExcelFormulaParser.EPPlus.Tests\Files\lite
var fileInfo = new FileInfo("..\\..\\..\\ExcelFormulaParser.EPPlus.Tests\\Files\\lite_olika_namn.xlsx");
using (var package = new ExcelPackage(fileInfo))
{
var provider = new EPPlusExcelDataProvider(package);
var parser = new FormulaParser(provider);
var result = parser.ParseAt("C4");
Assert.AreEqual(2d, result);
}
}
public void ChainTest1()
{
var cbt = new ChainTestBuilder();
using (var package = cbt.Build())
{
package.SaveAs(new System.IO.FileInfo("c:\\Temp\\chaintest.xlsx"));
var provider = new EPPlusExcelDataProvider(package);
var startTime = DateTime.Now;
var parser = new FormulaParser(provider);
var result = parser.ParseAt("C1");
var elapsed = DateTime.Now.Subtract(startTime);
}
}
public void LoadTestFromJan()
{
var fileInfo = new FileInfo("c:\\temp\\xl\\Kedjor-prestanda test.xlsx");
using(var package = new ExcelPackage(fileInfo))
{
var provider = new EPPlusExcelDataProvider(package);
var parser = new FormulaParser(provider);
var startTime = DateTime.Now;
var result = parser.ParseAt("B1");
var elapsed = DateTime.Now.Subtract(startTime);
}
}
