public new IXLTableRows Rows(string rows)
{
var retVal = new XLTableRows(Worksheet.Style);
var rowPairs = rows.Split(',');
foreach (string tPair in rowPairs.Select(pair => pair.Trim()))
{
String firstRow;
String lastRow;
if (tPair.Contains(':') || tPair.Contains('-'))
{
var rowRange = XLHelper.SplitRange(tPair);
firstRow = rowRange[0];
lastRow = rowRange[1];
}
else
{
firstRow = tPair;
lastRow = tPair;
}
foreach (IXLTableRow row in Rows(Int32.Parse(firstRow), Int32.Parse(lastRow)))
{
retVal.Add(row);
}
}
return(retVal);
}
public new IXLTableRows Rows(int firstRow, int lastRow)
{
var retVal = new XLTableRows(Worksheet.Style);
for (int ro = firstRow; ro <= lastRow; ro++)
{
retVal.Add(Row(ro));
}
return(retVal);
}
public IXLTableRows Rows(Func <IXLTableRow, Boolean> predicate = null)
{
var retVal = new XLTableRows(Worksheet.Style);
Int32 rowCount = _range.RowCount();
for (int r = 1; r <= rowCount; r++)
{
var row = Row(r);
if (predicate == null || predicate(row))
{
retVal.Add(row);
}
}
return(retVal);
}
public IXLTableRows RowsUsed(Boolean includeFormats, Func <IXLTableRow, Boolean> predicate = null)
{
var rows = new XLTableRows(Worksheet.Style);
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 XLTableRows RowsUsed(XLCellsUsedOptions options, Func <IXLTableRow, Boolean> predicate = null)
{
var rows = new XLTableRows(Worksheet.Style);
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);
}
internal static IXLTableRows InsertRowsWithoutEvents(Func <int, bool, IXLRangeRows> insertFunc,
XLTableRange tableRange, Int32 numberOfRows,
Boolean expandTable)
{
var ws = tableRange.Worksheet;
var tracking = ws.EventTrackingEnabled;
ws.EventTrackingEnabled = false;
var rows = new XLTableRows(ws.Style);
var inserted = insertFunc(numberOfRows, false);
inserted.ForEach(r => rows.Add(new XLTableRow(tableRange, r as XLRangeRow)));
if (expandTable)
{
tableRange.Table.ExpandTableRows(numberOfRows);
}
ws.EventTrackingEnabled = tracking;
return(rows);
}
internal static IXLTableRows InsertRowsWithoutEvents(Func<int, bool, IXLRangeRows> insertFunc,
XLTableRange tableRange, Int32 numberOfRows,
Boolean expandTable)
{
var ws = tableRange.Worksheet;
var tracking = ws.EventTrackingEnabled;
ws.EventTrackingEnabled = false;
var rows = new XLTableRows(ws.Style);
var inserted = insertFunc(numberOfRows, false);
inserted.ForEach(r => rows.Add(new XLTableRow(tableRange, r as XLRangeRow)));
if (expandTable)
tableRange.Table.ExpandTableRows(numberOfRows);
ws.EventTrackingEnabled = tracking;
return rows;
}
public IXLTableRows RowsUsed(Boolean includeFormats, Func<IXLTableRow, Boolean> predicate = null)
{
var rows = new XLTableRows(Worksheet.Style);
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 new IXLTableRows Rows(string rows)
{
var retVal = new XLTableRows(Worksheet.Style);
var rowPairs = rows.Split(',');
foreach (string tPair in rowPairs.Select(pair => pair.Trim()))
{
String firstRow;
String lastRow;
if (tPair.Contains(':') || tPair.Contains('-'))
{
var rowRange = XLHelper.SplitRange(tPair);
firstRow = rowRange[0];
lastRow = rowRange[1];
}
else
{
firstRow = tPair;
lastRow = tPair;
}
foreach (IXLTableRow row in Rows(Int32.Parse(firstRow), Int32.Parse(lastRow)))
retVal.Add(row);
}
return retVal;
}
public new IXLTableRows Rows(int firstRow, int lastRow)
{
var retVal = new XLTableRows(Worksheet.Style);
for (int ro = firstRow; ro <= lastRow; ro++)
retVal.Add(Row(ro));
return retVal;
}
public IXLTableRows Rows(Func<IXLTableRow, Boolean> predicate = null)
{
var retVal = new XLTableRows(Worksheet.Style);
Int32 rowCount = _range.RowCount();
for (int r = 1; r <= rowCount; r++)
{
var row = Row(r);
if (predicate == null || predicate(row))
retVal.Add(row);
else
row.Dispose();
}
return retVal;
}
