Interface IXLTableRange

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLTableRange : IXLRange, IXLRangeBase, IXLAddressable

Inherited Members

IXLRange.Cell(int, int)

IXLRange.Cell(string)

IXLRange.Cell(int, string)

IXLRange.Cell(IXLAddress)

IXLRange.Column(int)

IXLRange.Column(string)

IXLRange.FirstColumn(Func<IXLRangeColumn, bool>)

IXLRange.FirstColumnUsed(XLCellsUsedOptions, Func<IXLRangeColumn, bool>)

IXLRange.FirstColumnUsed(Func<IXLRangeColumn, bool>)

IXLRange.LastColumn(Func<IXLRangeColumn, bool>)

IXLRange.LastColumnUsed(XLCellsUsedOptions, Func<IXLRangeColumn, bool>)

IXLRange.LastColumnUsed(Func<IXLRangeColumn, bool>)

IXLRange.Columns(Func<IXLRangeColumn, bool>)

IXLRange.Columns(int, int)

IXLRange.Columns(string, string)

IXLRange.Columns(string)

IXLRange.FindColumn(Func<IXLRangeColumn, bool>)

IXLRange.FindRow(Func<IXLRangeRow, bool>)

IXLRange.FirstRow(Func<IXLRangeRow, bool>)

IXLRange.FirstRowUsed(XLCellsUsedOptions, Func<IXLRangeRow, bool>)

IXLRange.FirstRowUsed(Func<IXLRangeRow, bool>)

IXLRange.LastRow(Func<IXLRangeRow, bool>)

IXLRange.LastRowUsed(XLCellsUsedOptions, Func<IXLRangeRow, bool>)

IXLRange.LastRowUsed(Func<IXLRangeRow, bool>)

IXLRange.Rows(Func<IXLRangeRow, bool>)

IXLRange.Range(IXLRangeAddress)

IXLRange.Range(string)

IXLRange.Range(IXLCell, IXLCell)

IXLRange.Range(string, string)

IXLRange.Range(IXLAddress, IXLAddress)

IXLRange.Ranges(string)

IXLRange.Range(int, int, int, int)

IXLRange.RowCount()

IXLRange.ColumnCount()

IXLRange.InsertColumnsAfter(int)

IXLRange.InsertColumnsAfter(int, bool)

IXLRange.InsertColumnsBefore(int)

IXLRange.InsertColumnsBefore(int, bool)

IXLRange.InsertRowsAbove(int, bool)

IXLRange.InsertRowsBelow(int, bool)

IXLRange.Delete(XLShiftDeletedCells)

IXLRange.Transpose(XLTransposeOptions)

IXLRange.AsTable()

IXLRange.AsTable(string)

IXLRange.CreateTable()

IXLRange.CreateTable(string)

IXLRange.RangeUsed()

IXLRange.CopyTo(IXLCell)

IXLRange.CopyTo(IXLRangeBase)

IXLRange.SortRows

IXLRange.SortColumns

IXLRange.Sort()

IXLRange.Sort(string, XLSortOrder, bool, bool)

IXLRange.Sort(int, XLSortOrder, bool, bool)

IXLRange.SortLeftToRight(XLSortOrder, bool, bool)

IXLRange.Clear(XLClearOptions)

IXLRange.RowsUsed(XLCellsUsedOptions, Func<IXLRangeRow, bool>)

IXLRange.RowsUsed(Func<IXLRangeRow, bool>)

IXLRange.ColumnsUsed(XLCellsUsedOptions, Func<IXLRangeColumn, bool>)

IXLRange.ColumnsUsed(Func<IXLRangeColumn, bool>)

IXLRangeBase.Worksheet

IXLRangeBase.Value

IXLRangeBase.FormulaA1

IXLRangeBase.FormulaArrayA1

IXLRangeBase.FormulaR1C1

IXLRangeBase.Style

IXLRangeBase.ShareString

IXLRangeBase.Hyperlinks

IXLRangeBase.Cells()

IXLRangeBase.Cells(bool)

IXLRangeBase.Cells(bool, XLCellsUsedOptions)

IXLRangeBase.Cells(string)

IXLRangeBase.Cells(Func<IXLCell, bool>)

IXLRangeBase.CellsUsed()

IXLRangeBase.CellsUsed(XLCellsUsedOptions)

IXLRangeBase.CellsUsed(Func<IXLCell, bool>)

IXLRangeBase.CellsUsed(XLCellsUsedOptions, Func<IXLCell, bool>)

IXLRangeBase.Search(string, CompareOptions, bool)

IXLRangeBase.FirstCell()

IXLRangeBase.FirstCellUsed()

IXLRangeBase.FirstCellUsed(XLCellsUsedOptions)

IXLRangeBase.FirstCellUsed(Func<IXLCell, bool>)

IXLRangeBase.FirstCellUsed(XLCellsUsedOptions, Func<IXLCell, bool>)

IXLRangeBase.LastCell()

IXLRangeBase.LastCellUsed()

IXLRangeBase.LastCellUsed(XLCellsUsedOptions)

IXLRangeBase.LastCellUsed(Func<IXLCell, bool>)

IXLRangeBase.LastCellUsed(XLCellsUsedOptions, Func<IXLCell, bool>)

IXLRangeBase.Contains(string)

IXLRangeBase.Contains(IXLRangeBase)

IXLRangeBase.Contains(IXLCell)

IXLRangeBase.Intersects(string)

IXLRangeBase.Intersects(IXLRangeBase)

IXLRangeBase.Unmerge()

IXLRangeBase.Merge()

IXLRangeBase.Merge(bool)

IXLRangeBase.AddToNamed(string)

IXLRangeBase.AddToNamed(string, XLScope)

IXLRangeBase.AddToNamed(string, XLScope, string)

IXLRangeBase.DeleteComments()

IXLRangeBase.SetValue(XLCellValue)

IXLRangeBase.AsRange()

IXLRangeBase.IsMerged()

IXLRangeBase.IsEmpty()

IXLRangeBase.IsEmpty(XLCellsUsedOptions)

IXLRangeBase.IsEntireColumn()

IXLRangeBase.IsEntireRow()

IXLRangeBase.IsEntireSheet()

IXLRangeBase.CreatePivotTable(IXLCell, string)

IXLRangeBase.SetAutoFilter()

IXLRangeBase.SetAutoFilter(bool)

IXLRangeBase.GetDataValidation()

IXLRangeBase.CreateDataValidation()

IXLRangeBase.SetDataValidation()

IXLRangeBase.AddConditionalFormat()

IXLRangeBase.Select()

IXLRangeBase.Grow()

IXLRangeBase.Grow(int)

IXLRangeBase.Shrink()

IXLRangeBase.Shrink(int)

IXLRangeBase.Intersection(IXLRangeBase, Func<IXLCell, bool>, Func<IXLCell, bool>)

IXLRangeBase.SurroundingCells(Func<IXLCell, bool>)

IXLRangeBase.Union(IXLRangeBase, Func<IXLCell, bool>, Func<IXLCell, bool>)

IXLRangeBase.Difference(IXLRangeBase, Func<IXLCell, bool>, Func<IXLCell, bool>)

IXLRangeBase.Relative(IXLRangeBase, IXLRangeBase)

IXLAddressable.RangeAddress

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

Table

IXLTable Table { get; }

Property Value

IXLTable

Methods

FirstRow(Func<IXLTableRow, bool>)

IXLTableRow FirstRow(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

FirstRowUsed(XLCellsUsedOptions, Func<IXLTableRow, bool>)

IXLTableRow FirstRowUsed(XLCellsUsedOptions options, Func<IXLTableRow, bool> predicate = null)

Parameters

options XLCellsUsedOptions

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

FirstRowUsed(Func<IXLTableRow, bool>)

IXLTableRow FirstRowUsed(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

InsertRowsAbove(int)

IXLTableRows InsertRowsAbove(int numberOfRows)

Parameters

numberOfRows int

Returns

IXLTableRows

InsertRowsBelow(int)

IXLTableRows InsertRowsBelow(int numberOfRows)

Parameters

numberOfRows int

Returns

IXLTableRows

LastRow(Func<IXLTableRow, bool>)

IXLTableRow LastRow(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

LastRowUsed(XLCellsUsedOptions, Func<IXLTableRow, bool>)

IXLTableRow LastRowUsed(XLCellsUsedOptions options, Func<IXLTableRow, bool> predicate = null)

Parameters

options XLCellsUsedOptions

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

LastRowUsed(Func<IXLTableRow, bool>)

IXLTableRow LastRowUsed(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRow

Row(int)

Rows the specified row.

IXLTableRow Row(int row)

Parameters

row int

1-based row number relative to the first row of this range.

Returns

IXLTableRow

Rows(Func<IXLTableRow, bool>)

IXLTableRows Rows(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRows

Rows(int, int)

Returns a subset of the rows

IXLTableRows Rows(int firstRow, int lastRow)

Parameters

firstRow int

The first row to return. 1-based row number relative to the first row of this range.

lastRow int

The last row to return. 1-based row number relative to the first row of this range.

Returns

IXLTableRows

Rows(string)

IXLTableRows Rows(string rows)

Parameters

rows string

Returns

IXLTableRows

RowsUsed(XLCellsUsedOptions, Func<IXLTableRow, bool>)

IXLTableRows RowsUsed(XLCellsUsedOptions options, Func<IXLTableRow, bool> predicate = null)

Parameters

options XLCellsUsedOptions

predicate Func<IXLTableRow, bool>

Returns

IXLTableRows

RowsUsed(Func<IXLTableRow, bool>)

IXLTableRows RowsUsed(Func<IXLTableRow, bool> predicate = null)

Parameters

predicate Func<IXLTableRow, bool>

Returns

IXLTableRows