Class RangeExtensions¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Extension methods for ExcelRangeBase

public static class RangeExtensions

Inheritance¶

object ← RangeExtensions

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods¶

SkipColumns(ExcelRangeBase, int)¶

Returns a new range, created by skipping a number of columns from the start.

public static ExcelRangeBase SkipColumns(this ExcelRangeBase range, int count)

Parameters¶

range ExcelRangeBase

The source range

count int

The number of columns to skip

Returns¶

ExcelRangeBase

The result range

SkipRows(ExcelRangeBase, int)¶

Returns a new range, created by skipping a number of rows from the start.

public static ExcelRangeBase SkipRows(this ExcelRangeBase range, int count)

Parameters¶

range ExcelRangeBase

The source range

count int

The number of rows to skip

Returns¶

ExcelRangeBase

The result range

TakeColumns(ExcelRangeBase, int)¶

Returns a new range, created by taking a number of columns from the start. If count is greater than number of columns in the source range the entire source range will be returned.

public static ExcelRangeBase TakeColumns(this ExcelRangeBase range, int count)

Parameters¶

range ExcelRangeBase

The source range

count int

The number of columns to take

Returns¶

ExcelRangeBase

The result range

TakeColumnsBetween(ExcelRangeBase, int, int)¶

Returns a new range, created by taking a specific number of columns between from the offset parameter.

public static ExcelRangeBase TakeColumnsBetween(this ExcelRangeBase range, int offset, int count)

Parameters¶

range ExcelRangeBase

The source range

offset int

Offset of the start-column (zero-based)

count int

The number of columns to take

Returns¶

ExcelRangeBase

The result range

TakeRows(ExcelRangeBase, int)¶

Returns a new range, created by taking a number of rows from the start. If count is greater than number of rows in the source range the entire source range will be returned.

public static ExcelRangeBase TakeRows(this ExcelRangeBase range, int count)

Parameters¶

range ExcelRangeBase

The source range

count int

The number of columns to take

Returns¶

ExcelRangeBase

The result range

TakeRowsBetween(ExcelRangeBase, int, int)¶

Returns a new range, created by taking a specific number of rows based on the offset parameter.

public static ExcelRangeBase TakeRowsBetween(this ExcelRangeBase range, int offset, int count)

Parameters¶

range ExcelRangeBase

The source range

offset int

Offset of the start-row (zero-based)

count int

The number of rows to take

Returns¶

ExcelRangeBase

The result range

TakeSingleCell(ExcelRangeBase, int, int)¶

Returns a single cell within a range

public static ExcelRangeBase TakeSingleCell(this ExcelRangeBase range, int rowOffset, int columnOffset)

Parameters¶

range ExcelRangeBase

The source range

rowOffset int

Offset of the cell's row within the range (zero-based)

columnOffset int

Offset of the cell's column within the range (zero-based)

Returns¶

ExcelRangeBase

TakeSingleColumn(ExcelRangeBase, int)¶

Returns a single column as a new range.

public static ExcelRangeBase TakeSingleColumn(this ExcelRangeBase range, int offset)

Parameters¶

range ExcelRangeBase

The source range

offset int

Offset of the column (zero-based) in the source range

Returns¶

ExcelRangeBase

The requested row

TakeSingleRow(ExcelRangeBase, int)¶

Returns a single row as a new range.

public static ExcelRangeBase TakeSingleRow(this ExcelRangeBase range, int offset)

Parameters¶

range ExcelRangeBase

The source range

offset int

Offset of the row (zero-based) in the source range

Returns¶

ExcelRangeBase

The requested row