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);
}
}
public void Initialize()
{
var ms = new MemoryStream();
_package = new ExcelPackage(ms);
_workSheet = _package.Workbook.Worksheets.Add("Test");
for (var x = 1; x < 11; x++)
{
_workSheet.Cells["A" + x].Value = x;
}
var dataProvider = new EPPlusExcelDataProvider(_package);
_parser = new FormulaParser(dataProvider);
}
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 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);
}
}
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 Initialize()
{
var ms = new MemoryStream();
_package = new ExcelPackage(ms);
_workSheet = _package.Workbook.Worksheets.Add("Test");
for (var x = 1; x < 11; x++)
{
_workSheet.Cells["A" + x].Value = x;
}
var dataProvider = new EPPlusExcelDataProvider(_package);
_parser = new FormulaParser(dataProvider);
}
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);
}
}
