public void Initialize() { _package = new ExcelPackage(); _provider = new EpplusExcelDataProvider(_package); _parsingContext = ParsingContext.Create(); _parsingContext.Scopes.NewScope(RangeAddress.Empty); _worksheet = _package.Workbook.Worksheets.Add("testsheet"); }
private static ExcelDatabase GetDatabase(ExcelPackage package) { var provider = new EpplusExcelDataProvider(package); var sheet = package.Workbook.Worksheets.Add("test"); sheet.Cells["A1"].Value = "col1"; sheet.Cells["A2"].Value = 1; sheet.Cells["B1"].Value = "col2"; sheet.Cells["B2"].Value = 2; var database = new ExcelDatabase(provider, "A1:B2"); return database; }
public void CriteriaShouldIgnoreEmptyFields2() { using (var package = new ExcelPackage()) { var sheet = package.Workbook.Worksheets.Add("test"); sheet.Cells["A1"].Value = "Crit1"; sheet.Cells["A2"].Value = 1; var provider = new EpplusExcelDataProvider(package); var criteria = new ExcelDatabaseCriteria(provider, "A1:B2"); Assert.AreEqual(1, criteria.Items.Count); Assert.AreEqual("crit1", criteria.Items.Keys.First().ToString()); Assert.AreEqual(1, criteria.Items.Values.Last()); } }
public void CompileMultiCellReferenceAbsolute() { var parsingContext = ParsingContext.Create(); var file = new FileInfo("filename.xlsx"); using (var package = new ExcelPackage(file)) using (var sheet = package.Workbook.Worksheets.Add("NewSheet")) using (var excelDataProvider = new EpplusExcelDataProvider(package)) { var rangeAddressFactory = new RangeAddressFactory(excelDataProvider); using (parsingContext.Scopes.NewScope(rangeAddressFactory.Create("NewSheet", 3, 3))) { var expression = new ExcelAddressExpression("$A$1:$A$5", excelDataProvider, parsingContext); var result = expression.Compile(); var rangeInfo = result.Result as ExcelDataProvider.IRangeInfo; Assert.IsNotNull(rangeInfo); Assert.AreEqual("$A$1:$A$5", rangeInfo.Address.Address); // Enumerating the range still yields no results. Assert.AreEqual(0, rangeInfo.Count()); } } }
public void CompileSingleCellReferenceWithValue() { var parsingContext = ParsingContext.Create(); var file = new FileInfo("filename.xlsx"); using (var package = new ExcelPackage(file)) using (var sheet = package.Workbook.Worksheets.Add("NewSheet")) using (var excelDataProvider = new EpplusExcelDataProvider(package)) { sheet.Cells[1, 1].Value = "Value"; var rangeAddressFactory = new RangeAddressFactory(excelDataProvider); using (parsingContext.Scopes.NewScope(rangeAddressFactory.Create("NewSheet", 3, 3))) { var expression = new ExcelAddressExpression("A1", excelDataProvider, parsingContext); var result = expression.Compile(); Assert.AreEqual("Value", result.Result); } } }
public void CompileSingleCellReferenceResolveToRangeRowAbsolute() { var parsingContext = ParsingContext.Create(); var file = new FileInfo("filename.xlsx"); using (var package = new ExcelPackage(file)) using (var sheet = package.Workbook.Worksheets.Add("NewSheet")) using (var excelDataProvider = new EpplusExcelDataProvider(package)) { var rangeAddressFactory = new RangeAddressFactory(excelDataProvider); using (parsingContext.Scopes.NewScope(rangeAddressFactory.Create("NewSheet", 3, 3))) { var expression = new ExcelAddressExpression("$A1", excelDataProvider, parsingContext); expression.ResolveAsRange = true; var result = expression.Compile(); var rangeInfo = result.Result as ExcelDataProvider.IRangeInfo; Assert.IsNotNull(rangeInfo); Assert.AreEqual("$A1", rangeInfo.Address.Address); } } }
public void CompileMultiCellReferenceWithValues() { var parsingContext = ParsingContext.Create(); var file = new FileInfo("filename.xlsx"); using (var package = new ExcelPackage(file)) using (var sheet = package.Workbook.Worksheets.Add("NewSheet")) using (var excelDataProvider = new EpplusExcelDataProvider(package)) { sheet.Cells[1, 1].Value = "Value1"; sheet.Cells[2, 1].Value = "Value2"; sheet.Cells[3, 1].Value = "Value3"; sheet.Cells[4, 1].Value = "Value4"; sheet.Cells[5, 1].Value = "Value5"; var rangeAddressFactory = new RangeAddressFactory(excelDataProvider); using (parsingContext.Scopes.NewScope(rangeAddressFactory.Create("NewSheet", 3, 3))) { var expression = new ExcelAddressExpression("A1:A5", excelDataProvider, parsingContext); var result = expression.Compile(); var rangeInfo = result.Result as ExcelDataProvider.IRangeInfo; Assert.IsNotNull(rangeInfo); Assert.AreEqual("A1:A5", rangeInfo.Address.Address); Assert.AreEqual(5, rangeInfo.Count()); for (int i = 1; i <= 5; i++) { var rangeItem = rangeInfo.ElementAt(i - 1); Assert.AreEqual("Value" + i, rangeItem.Value); } } } }