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 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); } }