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; }