public override IEnumerable <object> GetRangeValues(string address) { SetCurrentWorksheet(ExcelAddressInfo.Parse(address)); var addr = new ExcelAddress(address); var wsName = string.IsNullOrEmpty(addr.WorkSheet) ? _currentWorksheet.Name : addr.WorkSheet; var ws = _package.Workbook.Worksheets[wsName]; return((IEnumerable <object>)(new CellsStoreEnumerator <ExcelCoreValue>(ws._values, addr._fromRow, addr._fromCol, addr._toRow, addr._toCol))); }
public override void SetCellValue(string address, object value) { var addressInfo = ExcelAddressInfo.Parse(address); var ra = _rangeAddressFactory.Create(address); SetCurrentWorksheet(addressInfo); var valueInfo = (ICalcEngineValueInfo)_currentWorksheet; valueInfo.SetFormulaValue(ra.FromRow + 1, ra.FromCol + 1, value); }
public override ExcelCell GetCellValue(string address) { var addressInfo = ExcelAddressInfo.Parse(address); SetCurrentWorksheet(addressInfo); var cell = _currentWorksheet.Cells[addressInfo.AddressOnSheet].FirstOrDefault(); if (cell != null) { return(new ExcelCell(cell.Value, cell.Formula, cell.Start.Column, cell.Start.Row)); } return(null); }
public override IEnumerable <ExcelCell> GetRangeValues(string address) { var returnList = new List <ExcelCell>(); var addressInfo = ExcelAddressInfo.Parse(address); SetCurrentWorksheet(addressInfo); var range = _currentWorksheet.Cells[addressInfo.AddressOnSheet]; foreach (var cell in range) { returnList.Add(new ExcelCell(cell.Value, cell.Formula, cell.Start.Column, cell.Start.Row)); } return(returnList); }
public void AddressOnSheetShouldBeSameAsAddressIfNoWorksheetIsSpecified() { var info = ExcelAddressInfo.Parse("A1:A2"); Assert.AreEqual("A1:A2", info.AddressOnSheet); }
public void ParseShouldSetAddressOnSheet() { var info = ExcelAddressInfo.Parse("Worksheet!A1:A2"); Assert.AreEqual("A1:A2", info.AddressOnSheet); }
public void ShouldSetEndCell() { var info = ExcelAddressInfo.Parse("A1:A2"); Assert.AreEqual("A2", info.EndCell); }
public void ShouldIndicateMultipleCellsWhenAddressContainsAColon() { var info = ExcelAddressInfo.Parse("A1:A2"); Assert.IsTrue(info.IsMultipleCells); }
public void WorksheetIsSpecifiedShouldBeTrueWhenWorksheetIsSupplied() { var info = ExcelAddressInfo.Parse("Worksheet!A1"); Assert.IsTrue(info.WorksheetIsSpecified); }
public void ParseShouldSetWorksheet() { var info = ExcelAddressInfo.Parse("Worksheet!A1"); Assert.AreEqual("Worksheet", info.Worksheet); }
public void ParseShouldThrowIfAddressIsNull() { ExcelAddressInfo.Parse(null); }