public IXLCells CellsUsed(Boolean includeFormats)
{
var cells = new XLCells(true, includeFormats);
foreach (XLRangeRow container in _ranges)
cells.Add(container.RangeAddress);
return cells;
}
public IXLCells CellsUsed()
{
var cells = new XLCells(true, false);
foreach (XLRangeRow container in _ranges)
cells.Add(container.RangeAddress);
return cells;
}
public IXLCells CellsUsed(Boolean includeFormats)
{
var cells = new XLCells(true, includeFormats);
foreach (XLRow container in _rows)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells CellsUsed()
{
var cells = new XLCells(true, false);
foreach (XLRow container in _rows)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells Cells()
{
var cells = new XLCells(false, false);
foreach (XLTableRow container in _ranges)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells CellsUsed(XLCellsUsedOptions options)
{
var cells = new XLCells(usedCellsOnly: true, options: options);
foreach (XLRangeColumn container in _ranges)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells Cells()
{
var cells = new XLCells(usedCellsOnly: false, options: XLCellsUsedOptions.AllContents);
foreach (XLRangeColumn container in _ranges)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells Cells()
{
var cells = new XLCells(false, false);
foreach (XLColumn container in _columns)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells CellsUsed(XLCellsUsedOptions options)
{
var cells = new XLCells(true, options);
foreach (XLColumn container in _columns)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells Cells()
{
var cells = new XLCells(false, XLCellsUsedOptions.AllContents);
foreach (XLTableRow container in _ranges)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public IXLCells CellsUsed()
{
var cells = new XLCells(true, XLCellsUsedOptions.AllContents);
foreach (XLRow container in _rows)
{
cells.Add(container.RangeAddress);
}
return(cells);
}
public new IXLCells Cells(string cellsInRow)
{
var retVal = new XLCells(false, false);
var rangePairs = cellsInRow.Split(',');
foreach (string pair in rangePairs)
{
retVal.Add(Range(pair.Trim()).RangeAddress);
}
return(retVal);
}
public override IXLCells Cells(String cellsInColumn)
{
var retVal = new XLCells(false, XLCellsUsedOptions.All);
var rangePairs = cellsInColumn.Split(',');
foreach (string pair in rangePairs)
{
retVal.Add(Range(pair.Trim()).RangeAddress);
}
return(retVal);
}
public IXLCells FindCells(Func <IXLCell, Boolean> predicate)
{
var cells = new XLCells(false, false);
foreach (XLWorksheet ws in WorksheetsInternal)
{
foreach (XLCell cell in ws.CellsUsed(true))
{
if (predicate(cell))
{
cells.Add(cell);
}
}
}
return(cells);
}
