Interface IXLRows

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLRows : IEnumerable<IXLRow>, IEnumerable

Inherited Members

IEnumerable<IXLRow>.GetEnumerator()

Extension Methods

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

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

Properties

Height

Sets the height of all rows.

double Height { set; }

Property Value

double

The height of all rows.

Style

IXLStyle Style { get; set; }

Property Value

IXLStyle

Methods

AddHorizontalPageBreaks()

Adds a horizontal page break after these rows.

IXLRows AddHorizontalPageBreaks()

Returns

IXLRows

AdjustToContents()

Adjusts the height of all rows based on its contents.

IXLRows AdjustToContents()

Returns

IXLRows

AdjustToContents(double, double)

IXLRows AdjustToContents(double minHeight, double maxHeight)

Parameters

minHeight double

maxHeight double

Returns

IXLRows

AdjustToContents(int)

Adjusts the height of all rows based on its contents, starting from the startColumn.

IXLRows AdjustToContents(int startColumn)

Parameters

startColumn int

The column to start calculating the row height.

Returns

IXLRows

AdjustToContents(int, double, double)

IXLRows AdjustToContents(int startColumn, double minHeight, double maxHeight)

Parameters

startColumn int

minHeight double

maxHeight double

Returns

IXLRows

AdjustToContents(int, int)

Adjusts the height of all rows based on its contents, starting from the startColumn and ending at endColumn.

IXLRows AdjustToContents(int startColumn, int endColumn)

Parameters

startColumn int

The column to start calculating the row height.

endColumn int

The column to end calculating the row height.

Returns

IXLRows

AdjustToContents(int, int, double, double)

IXLRows AdjustToContents(int startColumn, int endColumn, double minHeight, double maxHeight)

Parameters

startColumn int

endColumn int

minHeight double

maxHeight double

Returns

IXLRows

Cells()

Returns the collection of cells.

IXLCells Cells()

Returns

IXLCells

CellsUsed()

Returns the collection of cells that have a value.

IXLCells CellsUsed()

Returns

IXLCells

CellsUsed(XLCellsUsedOptions)

Returns the collection of cells that have a value.

IXLCells CellsUsed(XLCellsUsedOptions options)

Parameters

options XLCellsUsedOptions

The options to determine whether a cell is used.

Returns

IXLCells

Clear(XLClearOptions)

Clears the contents of these rows.

IXLRows Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLRows

Collapse()

Show all rows as collapsed.

void Collapse()

Delete()

Deletes all rows and shifts the rows below them accordingly.

void Delete()

Expand()

Expands all rows (if they're collapsed).

void Expand()

Group()

Increments the outline level of all rows by 1.

void Group()

Group(bool)

Increments the outline level of all rows by 1.

void Group(bool collapse)

Parameters

collapse bool

If set to true the rows will be shown collapsed.

Group(int)

Sets outline level for all rows.

void Group(int outlineLevel)

Parameters

outlineLevel int

The outline level.

Group(int, bool)

Sets outline level for all rows.

void Group(int outlineLevel, bool collapse)

Parameters

outlineLevel int

The outline level.

collapse bool

If set to true the rows will be shown collapsed.

Hide()

Hides all rows.

void Hide()

Select()

void Select()

Ungroup()

Decrements the outline level of all rows by 1.

void Ungroup()

Ungroup(bool)

Decrements the outline level of all rows by 1.

void Ungroup(bool fromAll)

Parameters

fromAll bool

If set to true it will remove the rows from all outline levels.

Unhide()

Unhides all rows.

void Unhide()