Table of Contents

Interface IXLRangeRow

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public interface IXLRangeRow : IXLRangeBase, IXLAddressable
Inherited Members
Extension Methods

Methods

Cell(int)

Gets the cell in the specified column.

IXLCell Cell(int columnNumber)

Parameters

columnNumber int

The cell's column.

Returns

IXLCell

Cell(string)

Gets the cell in the specified column.

IXLCell Cell(string columnLetter)

Parameters

columnLetter string

The cell's column.

Returns

IXLCell

CellCount() 

int CellCount()

Returns

int

Cells(int, int)

Returns the specified group of cells.

IXLCells Cells(int firstColumn, int lastColumn)

Parameters

firstColumn int

The first column in the group of cells to return.

lastColumn int

The last column in the group of cells to return.

Returns

IXLCells

Cells(string)

Returns the specified group of cells, separated by commas.

e.g. Cells("1"), Cells("1:5"), Cells("1:2,4:5")

IXLCells Cells(string cellsInRow)

Parameters

cellsInRow string

The row's cells to return.

Returns

IXLCells

Cells(string, string)

Returns the specified group of cells.

IXLCells Cells(string firstColumn, string lastColumn)

Parameters

firstColumn string

The first column in the group of cells to return.

lastColumn string

The last column in the group of cells to return.

Returns

IXLCells

Clear(XLClearOptions)

Clears the contents of this row.

IXLRangeRow Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLRangeRow

CopyTo(IXLCell) 

IXLRangeRow CopyTo(IXLCell target)

Parameters

target IXLCell

Returns

IXLRangeRow

CopyTo(IXLRangeBase) 

IXLRangeRow CopyTo(IXLRangeBase target)

Parameters

target IXLRangeBase

Returns

IXLRangeRow

Delete()

Deletes this range and shifts the cells below.

void Delete()

Delete(XLShiftDeletedCells)

Deletes this range and shifts the surrounding cells accordingly.

void Delete(XLShiftDeletedCells shiftDeleteCells)

Parameters

shiftDeleteCells XLShiftDeletedCells

How to shift the surrounding cells.

InsertCellsAfter(int)

Inserts X number of cells to the right of this row.

All cells to the right of this row will be shifted X number of columns.

IXLCells InsertCellsAfter(int numberOfColumns)

Parameters

numberOfColumns int

Number of cells to insert.

Returns

IXLCells

InsertCellsAfter(int, bool) 

IXLCells InsertCellsAfter(int numberOfColumns, bool expandRange)

Parameters

numberOfColumns int
expandRange bool

Returns

IXLCells

InsertCellsBefore(int)

Inserts X number of cells to the left of this row.

This row and all cells to the right of it will be shifted X number of columns.

IXLCells InsertCellsBefore(int numberOfColumns)

Parameters

numberOfColumns int

Number of cells to insert.

Returns

IXLCells

InsertCellsBefore(int, bool) 

IXLCells InsertCellsBefore(int numberOfColumns, bool expandRange)

Parameters

numberOfColumns int
expandRange bool

Returns

IXLCells

InsertRowsAbove(int)

Inserts X number of rows on top of this row.

This row and all cells below it will be shifted X number of rows.

IXLRangeRows InsertRowsAbove(int numberOfRows)

Parameters

numberOfRows int

Number of rows to insert.

Returns

IXLRangeRows

InsertRowsAbove(int, bool) 

IXLRangeRows InsertRowsAbove(int numberOfRows, bool expandRange)

Parameters

numberOfRows int
expandRange bool

Returns

IXLRangeRows

InsertRowsBelow(int)

Inserts X number of rows below this row.

All cells below this row will be shifted X number of rows.

IXLRangeRows InsertRowsBelow(int numberOfRows)

Parameters

numberOfRows int

Number of rows to insert.

Returns

IXLRangeRows

InsertRowsBelow(int, bool) 

IXLRangeRows InsertRowsBelow(int numberOfRows, bool expandRange)

Parameters

numberOfRows int
expandRange bool

Returns

IXLRangeRows

Row(IXLCell, IXLCell) 

IXLRangeRow Row(IXLCell start, IXLCell end)

Parameters

start IXLCell
end IXLCell

Returns

IXLRangeRow

Row(int, int) 

IXLRangeRow Row(int start, int end)

Parameters

start int
end int

Returns

IXLRangeRow

RowAbove() 

IXLRangeRow RowAbove()

Returns

IXLRangeRow

RowAbove(int) 

IXLRangeRow RowAbove(int step)

Parameters

step int

Returns

IXLRangeRow

RowBelow() 

IXLRangeRow RowBelow()

Returns

IXLRangeRow

RowBelow(int) 

IXLRangeRow RowBelow(int step)

Parameters

step int

Returns

IXLRangeRow

RowNumber()

Gets this row's number in the range

int RowNumber()

Returns

int

RowUsed(XLCellsUsedOptions) 

IXLRangeRow RowUsed(XLCellsUsedOptions options = XLCellsUsedOptions.AllContents)

Parameters

options XLCellsUsedOptions

Returns

IXLRangeRow

Rows(string) 

IXLRangeRows Rows(string rows)

Parameters

rows string

Returns

IXLRangeRows

Sort() 

IXLRangeRow Sort()

Returns

IXLRangeRow

SortLeftToRight(XLSortOrder, bool, bool) 

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

Parameters

sortOrder XLSortOrder
matchCase bool
ignoreBlanks bool

Returns

IXLRangeRow

WorksheetRow() 

IXLRow WorksheetRow()

Returns

IXLRow