Interface IXLColumns

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLColumns : IEnumerable<IXLColumn>, IEnumerable

Inherited Members

IEnumerable<IXLColumn>.GetEnumerator()

Extension Methods

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

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

Properties

Style

IXLStyle Style { get; set; }

Property Value

IXLStyle

Width

Sets the width of all columns.

double Width { set; }

Property Value

double

The width of all columns.

Methods

AddVerticalPageBreaks()

Adds a vertical page break after these columns.

IXLColumns AddVerticalPageBreaks()

Returns

IXLColumns

AdjustToContents()

Adjusts the width of all columns based on its contents.

IXLColumns AdjustToContents()

Returns

IXLColumns

AdjustToContents(double, double)

IXLColumns AdjustToContents(double minWidth, double maxWidth)

Parameters

minWidth double

maxWidth double

Returns

IXLColumns

AdjustToContents(int)

Adjusts the width of all columns based on its contents, starting from the startRow.

IXLColumns AdjustToContents(int startRow)

Parameters

startRow int

The row to start calculating the column width.

Returns

IXLColumns

AdjustToContents(int, double, double)

IXLColumns AdjustToContents(int startRow, double minWidth, double maxWidth)

Parameters

startRow int

minWidth double

maxWidth double

Returns

IXLColumns

AdjustToContents(int, int)

Adjusts the width of all columns based on its contents, starting from the startRow and ending at endRow.

IXLColumns AdjustToContents(int startRow, int endRow)

Parameters

startRow int

The row to start calculating the column width.

endRow int

The row to end calculating the column width.

Returns

IXLColumns

AdjustToContents(int, int, double, double)

IXLColumns AdjustToContents(int startRow, int endRow, double minWidth, double maxWidth)

Parameters

startRow int

endRow int

minWidth double

maxWidth double

Returns

IXLColumns

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

Returns the collection of cells that have a value.

IXLCells CellsUsed(bool includeFormats)

Parameters

includeFormats bool

if set to true will return all cells with a value or a style different than the default.

Returns

IXLCells

Clear(XLClearOptions)

Clears the contents of these columns.

IXLColumns Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLColumns

Collapse()

Show all columns as collapsed.

void Collapse()

Delete()

Deletes all columns and shifts the columns at the right of them accordingly.

void Delete()

Expand()

Expands all columns (if they're collapsed).

void Expand()

Group()

Increments the outline level of all columns by 1.

void Group()

Group(bool)

Increments the outline level of all columns by 1.

void Group(bool collapse)

Parameters

collapse bool

If set to true the columns will be shown collapsed.

Group(int)

Sets outline level for all columns.

void Group(int outlineLevel)

Parameters

outlineLevel int

The outline level.

Group(int, bool)

Sets outline level for all columns.

void Group(int outlineLevel, bool collapse)

Parameters

outlineLevel int

The outline level.

collapse bool

If set to true the columns will be shown collapsed.

Hide()

Hides all columns.

void Hide()

Select()

void Select()

Ungroup()

Decrements the outline level of all columns by 1.

void Ungroup()

Ungroup(bool)

Decrements the outline level of all columns by 1.

void Ungroup(bool fromAll)

Parameters

fromAll bool

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

Unhide()

Unhides all columns.

void Unhide()