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);
}
}
}
}
public void ShouldCallReturnResultFromProvider()
{
var expectedAddress = "A1";
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider
.Stub(x => x.GetRangeValues(expectedAddress))
.Return(new ExcelCell[] { CreateItem(1) });
var expression = new ExcelAddressExpression(expectedAddress, provider, _parsingContext);
var result = expression.Compile();
Assert.AreEqual(1, result.Result);
}
public void CompileShouldReturnAddress()
{
var expectedAddress = "A1";
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider
.Stub(x => x.GetRangeValues(expectedAddress))
.Return(new ExcelCell[] { CreateItem(1) });
var expression = new ExcelAddressExpression(expectedAddress, provider, _parsingContext);
expression.ParentIsLookupFunction = true;
var result = expression.Compile();
Assert.AreEqual(expectedAddress, result.Result);
}
public void CompileSingleCellReference()
{
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);
var result = expression.Compile();
Assert.IsNull(result.Result);
}
}
}
public void CompileSingleCellReferenceResolveToRangeAbsolute()
{
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", excelDataProvider, parsingContext);
expression.ResolveAsRange = true;
var result = expression.Compile();
var rangeInfo = result.Result as ExcelDataProvider.IRangeInfo;
Assert.IsNotNull(rangeInfo);
Assert.AreEqual("$A$1", rangeInfo.Address.Address);
}
}
}
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());
}
}
}
