ColumnBuilder

Namespace OfficeIMO.Excel.Fluent

Assembly OfficeIMO.Excel

Fluent builder for adjusting a single column (width, visibility) and writing cells in that column.

Inheritance

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

public ColumnBuilder AutoFit() #

Returns: ColumnBuilder

Auto-fits the column to its contents.

public ColumnBuilder Cell(Int32 row, Object value = null, String formula = null, String numberFormat = null) #

Returns: ColumnBuilder

Writes a cell in this column with optional value, formula, and number format.

row System.Int32 requiredposition: 0: 1-based row index.
value System.Object = null optionalposition: 1: Optional value.
formula System.String = null optionalposition: 2: Optional A1-style formula.
numberFormat System.String = null optionalposition: 3: Optional number format code.

public ColumnBuilder Hidden(Boolean hidden) #

Returns: ColumnBuilder

Hides or shows the column.

public ColumnBuilder Width(Double width) #

Returns: ColumnBuilder

Sets the column width (Excel column units).