Interface IXLTableRow

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLTableRow : IXLRangeRow, IXLRangeBase, IXLAddressable

Inherited Members

IXLRangeRow.Cell(int)

IXLRangeRow.Cell(string)

IXLRangeRow.Cells(string)

IXLRangeRow.Cells(int, int)

IXLRangeRow.Cells(string, string)

IXLRangeRow.InsertCellsAfter(int)

IXLRangeRow.InsertCellsAfter(int, bool)

IXLRangeRow.InsertCellsBefore(int)

IXLRangeRow.InsertCellsBefore(int, bool)

IXLRangeRow.InsertRowsAbove(int, bool)

IXLRangeRow.InsertRowsBelow(int, bool)

IXLRangeRow.Delete()

IXLRangeRow.Delete(XLShiftDeletedCells)

IXLRangeRow.RowNumber()

IXLRangeRow.CellCount()

IXLRangeRow.CopyTo(IXLCell)

IXLRangeRow.CopyTo(IXLRangeBase)

IXLRangeRow.Row(int, int)

IXLRangeRow.Row(IXLCell, IXLCell)

IXLRangeRow.Rows(string)

IXLRangeRow.WorksheetRow()

IXLRangeRow.RowUsed(XLCellsUsedOptions)

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(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>>)

Methods

Clear(XLClearOptions)

Clears the contents of this row.

IXLTableRow Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLTableRow

Field(int)

IXLCell Field(int index)

Parameters

index int

Returns

IXLCell

Field(string)

IXLCell Field(string name)

Parameters

name string

Returns

IXLCell

InsertRowsAbove(int)

IXLTableRows InsertRowsAbove(int numberOfRows)

Parameters

numberOfRows int

Returns

IXLTableRows

InsertRowsBelow(int)

IXLTableRows InsertRowsBelow(int numberOfRows)

Parameters

numberOfRows int

Returns

IXLTableRows

RowAbove()

IXLTableRow RowAbove()

Returns

IXLTableRow

RowAbove(int)

IXLTableRow RowAbove(int step)

Parameters

step int

Returns

IXLTableRow

RowBelow()

IXLTableRow RowBelow()

Returns

IXLTableRow

RowBelow(int)

IXLTableRow RowBelow(int step)

Parameters

step int

Returns

IXLTableRow

Sort()

IXLTableRow Sort()

Returns

IXLTableRow

SortLeftToRight(XLSortOrder, bool, bool)

IXLTableRow SortLeftToRight(XLSortOrder sortOrder = XLSortOrder.Ascending, bool matchCase = false, bool ignoreBlanks = true)

Parameters

sortOrder XLSortOrder

matchCase bool

ignoreBlanks bool

Returns

IXLTableRow