Table of Contents

Interface IXLRangeColumn

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

Methods

AsTable() 

IXLTable AsTable()

Returns

IXLTable

AsTable(string) 

IXLTable AsTable(string name)

Parameters

name string

Returns

IXLTable

Cell(int)

Gets the cell in the specified row.

IXLCell Cell(int rowNumber)

Parameters

rowNumber int

The cell's row.

Returns

IXLCell

CellCount() 

int CellCount()

Returns

int

Cells(int, int)

Returns the specified group of cells.

IXLCells Cells(int firstRow, int lastRow)

Parameters

firstRow int

The first row in the group of cells to return.

lastRow int

The last row 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 cellsInColumn)

Parameters

cellsInColumn string

The column cells to return.

Returns

IXLCells

Clear(XLClearOptions)

Clears the contents of this column.

IXLRangeColumn Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLRangeColumn

Column(IXLCell, IXLCell) 

IXLRangeColumn Column(IXLCell start, IXLCell end)

Parameters

start IXLCell
end IXLCell

Returns

IXLRangeColumn

Column(int, int) 

IXLRangeColumn Column(int start, int end)

Parameters

start int
end int

Returns

IXLRangeColumn

ColumnLeft() 

IXLRangeColumn ColumnLeft()

Returns

IXLRangeColumn

ColumnLeft(int) 

IXLRangeColumn ColumnLeft(int step)

Parameters

step int

Returns

IXLRangeColumn

ColumnLetter()

Gets this column's letter in the range

string ColumnLetter()

Returns

string

ColumnNumber()

Gets this column's number in the range

int ColumnNumber()

Returns

int

ColumnRight() 

IXLRangeColumn ColumnRight()

Returns

IXLRangeColumn

ColumnRight(int) 

IXLRangeColumn ColumnRight(int step)

Parameters

step int

Returns

IXLRangeColumn

ColumnUsed(XLCellsUsedOptions) 

IXLRangeColumn ColumnUsed(XLCellsUsedOptions options = XLCellsUsedOptions.AllContents)

Parameters

options XLCellsUsedOptions

Returns

IXLRangeColumn

Columns(string) 

IXLRangeColumns Columns(string columns)

Parameters

columns string

Returns

IXLRangeColumns

CopyTo(IXLCell) 

IXLRangeColumn CopyTo(IXLCell target)

Parameters

target IXLCell

Returns

IXLRangeColumn

CopyTo(IXLRangeBase) 

IXLRangeColumn CopyTo(IXLRangeBase target)

Parameters

target IXLRangeBase

Returns

IXLRangeColumn

CreateTable() 

IXLTable CreateTable()

Returns

IXLTable

CreateTable(string) 

IXLTable CreateTable(string name)

Parameters

name string

Returns

IXLTable

Delete()

Deletes this range and shifts the cells at the right.

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.

InsertCellsAbove(int)

Inserts X number of cells on top of this column.

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

IXLCells InsertCellsAbove(int numberOfRows)

Parameters

numberOfRows int

Number of cells to insert.

Returns

IXLCells

InsertCellsAbove(int, bool) 

IXLCells InsertCellsAbove(int numberOfRows, bool expandRange)

Parameters

numberOfRows int
expandRange bool

Returns

IXLCells

InsertCellsBelow(int)

Inserts X number of cells below this range.

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

IXLCells InsertCellsBelow(int numberOfRows)

Parameters

numberOfRows int

Number of cells to insert.

Returns

IXLCells

InsertCellsBelow(int, bool) 

IXLCells InsertCellsBelow(int numberOfRows, bool expandRange)

Parameters

numberOfRows int
expandRange bool

Returns

IXLCells

InsertColumnsAfter(int)

Inserts X number of columns to the right of this range.

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

IXLRangeColumns InsertColumnsAfter(int numberOfColumns)

Parameters

numberOfColumns int

Number of columns to insert.

Returns

IXLRangeColumns

InsertColumnsAfter(int, bool) 

IXLRangeColumns InsertColumnsAfter(int numberOfColumns, bool expandRange)

Parameters

numberOfColumns int
expandRange bool

Returns

IXLRangeColumns

InsertColumnsBefore(int)

Inserts X number of columns to the left of this range.

This range and all cells to the right of this range will be shifted X number of columns.

IXLRangeColumns InsertColumnsBefore(int numberOfColumns)

Parameters

numberOfColumns int

Number of columns to insert.

Returns

IXLRangeColumns

InsertColumnsBefore(int, bool) 

IXLRangeColumns InsertColumnsBefore(int numberOfColumns, bool expandRange)

Parameters

numberOfColumns int
expandRange bool

Returns

IXLRangeColumns

Sort(XLSortOrder, bool, bool) 

IXLRangeColumn Sort(XLSortOrder sortOrder = XLSortOrder.Ascending, bool matchCase = false, bool ignoreBlanks = true)

Parameters

sortOrder XLSortOrder
matchCase bool
ignoreBlanks bool

Returns

IXLRangeColumn

WorksheetColumn() 

IXLColumn WorksheetColumn()

Returns

IXLColumn