OfficeIMO

API Reference

Class

ColumnBuilder

Edit on GitHub
Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/Fluent/ColumnBuilder.cs:17

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

Inheritance

  • Object
  • ColumnBuilder

Methods

public ColumnBuilder AutoFit() #
OfficeIMO.Excel/Fluent/ColumnBuilder.cs:17
Returns: ColumnBuilder

Auto-fits the column to its contents.

public ColumnBuilder Cell(Int32 row, Object value = null, String formula = null, String numberFormat = null) #
OfficeIMO.Excel/Fluent/ColumnBuilder.cs:41
Returns: ColumnBuilder

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

Parameters

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) #
OfficeIMO.Excel/Fluent/ColumnBuilder.cs:29
Returns: ColumnBuilder

Hides or shows the column.

Parameters

hidden System.Boolean requiredposition: 0
public ColumnBuilder Width(Double width) #
OfficeIMO.Excel/Fluent/ColumnBuilder.cs:23
Returns: ColumnBuilder

Sets the column width (Excel column units).

Parameters

width System.Double requiredposition: 0