public IXLRangeRows Rows(string rows)
{
var retVal = new XLRangeRows();
var columnPairs = rows.Split(',');
foreach (string trimmedPair in columnPairs.Select(pair => pair.Trim()))
{
string firstColumn;
string lastColumn;
if (trimmedPair.Contains(':') || trimmedPair.Contains('-'))
{
var columnRange = trimmedPair.Contains('-')
? trimmedPair.Replace('-', ':').Split(':')
: trimmedPair.Split(':');
firstColumn = columnRange[0];
lastColumn = columnRange[1];
}
else
{
firstColumn = trimmedPair;
lastColumn = trimmedPair;
}
retVal.Add(Range(firstColumn, lastColumn).FirstRow());
}
return(retVal);
}
public IXLRangeRows Rows(String rows)
{
var retVal = new XLRangeRows();
var rowPairs = rows.Split(',');
foreach (string tPair in rowPairs.Select(pair => pair.Trim()))
{
String firstRow;
String lastRow;
if (tPair.Contains(':') || tPair.Contains('-'))
{
string[] rowRange = XLHelper.SplitRange(tPair);
firstRow = rowRange[0];
lastRow = rowRange[1];
}
else
{
firstRow = tPair;
lastRow = tPair;
}
foreach (IXLRangeRow row in Rows(Int32.Parse(firstRow), Int32.Parse(lastRow)))
{
retVal.Add(row);
}
}
return(retVal);
}
public IXLRangeRows Rows(Int32 firstRow, Int32 lastRow)
{
var retVal = new XLRangeRows();
for (int ro = firstRow; ro <= lastRow; ro++)
{
retVal.Add(Row(ro));
}
return(retVal);
}
public IXLRangeRows Rows(String rows)
{
var retVal = new XLRangeRows();
var rowPairs = rows.Split(',');
foreach (string pair in rowPairs)
{
using (var asRange = AsRange())
asRange.Rows(pair.Trim()).ForEach(retVal.Add);
}
return(retVal);
}
public IXLRangeRows Rows(Func <IXLRangeRow, Boolean> predicate = null)
{
var retVal = new XLRangeRows();
Int32 rowCount = RowCount();
for (Int32 r = 1; r <= rowCount; r++)
{
var row = Row(r);
if (predicate == null || predicate(row))
{
retVal.Add(Row(r));
}
}
return(retVal);
}
public XLRangeRows RowsUsed(Boolean includeFormats, Func <IXLRangeRow, Boolean> predicate = null)
{
XLRangeRows rows = new XLRangeRows();
Int32 rowCount = RowCount();
for (Int32 ro = 1; ro <= rowCount; ro++)
{
var row = Row(ro);
if (!row.IsEmpty(includeFormats) && (predicate == null || predicate(row)))
{
rows.Add(row);
}
}
return(rows);
}
internal XLRangeRows RowsUsed(XLCellsUsedOptions options, Func <IXLRangeRow, Boolean> predicate = null)
{
XLRangeRows rows = new XLRangeRows();
Int32 rowCount = RowCount();
for (Int32 ro = 1; ro <= rowCount; ro++)
{
var row = Row(ro);
if (!row.IsEmpty(options) && (predicate == null || predicate(row)))
{
rows.Add(row);
}
}
return(rows);
}
public IXLRangeRows Rows(String rows)
{
var retVal = new XLRangeRows();
var rowPairs = rows.Split(',');
foreach (string pair in rowPairs)
using (var asRange = AsRange())
asRange.Rows(pair.Trim()).ForEach(retVal.Add);
return retVal;
}
public XLRangeRows RowsUsed(Boolean includeFormats, Func<IXLRangeRow, Boolean> predicate = null)
{
XLRangeRows rows = new XLRangeRows();
Int32 rowCount = RowCount();
for (Int32 ro = 1; ro <= rowCount; ro++)
{
var row = Row(ro);
if (!row.IsEmpty(includeFormats) && (predicate == null || predicate(row)))
rows.Add(row);
else
row.Dispose();
}
return rows;
}
public IXLRangeRows Rows(String rows)
{
var retVal = new XLRangeRows();
var rowPairs = rows.Split(',');
foreach (string tPair in rowPairs.Select(pair => pair.Trim()))
{
String firstRow;
String lastRow;
if (tPair.Contains(':') || tPair.Contains('-'))
{
string[] rowRange = XLHelper.SplitRange(tPair);
firstRow = rowRange[0];
lastRow = rowRange[1];
}
else
{
firstRow = tPair;
lastRow = tPair;
}
foreach (IXLRangeRow row in Rows(Int32.Parse(firstRow), Int32.Parse(lastRow)))
retVal.Add(row);
}
return retVal;
}
public IXLRangeRows Rows(Int32 firstRow, Int32 lastRow)
{
var retVal = new XLRangeRows();
for (int ro = firstRow; ro <= lastRow; ro++)
retVal.Add(Row(ro));
return retVal;
}
public IXLRangeRows Rows(Func<IXLRangeRow, Boolean> predicate = null)
{
var retVal = new XLRangeRows();
Int32 rowCount = RowCount();
for (Int32 r = 1; r <= rowCount; r++)
{
var row = Row(r);
if (predicate == null || predicate(row))
retVal.Add(Row(r));
else
row.Dispose();
}
return retVal;
}
public IXLRangeRows Rows(string rows)
{
var retVal = new XLRangeRows();
var columnPairs = rows.Split(',');
foreach (string trimmedPair in columnPairs.Select(pair => pair.Trim()))
{
string firstColumn;
string lastColumn;
if (trimmedPair.Contains(':') || trimmedPair.Contains('-'))
{
var columnRange = trimmedPair.Contains('-')
? trimmedPair.Replace('-', ':').Split(':')
: trimmedPair.Split(':');
firstColumn = columnRange[0];
lastColumn = columnRange[1];
}
else
{
firstColumn = trimmedPair;
lastColumn = trimmedPair;
}
retVal.Add(Range(firstColumn, lastColumn).FirstRow());
}
return retVal;
}