OfficeIMO

API Reference

Class

TableBuilder

Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel

Fluent helpers for adding Excel tables over a range.

Inheritance

  • Object
  • TableBuilder

Methods

public TableBuilder Add(String range, Boolean hasHeader = true, String name = "", TableStyle style = TableStyleLight9, Boolean includeAutoFilter = true) #
Returns: TableBuilder

Adds a table over the specified A1 range with optional header, name, style and AutoFilter.

Parameters

range System.String requiredposition: 0
hasHeader System.Boolean = true optionalposition: 1
name System.String = "" optionalposition: 2
style OfficeIMO.Excel.TableStyle = TableStyleLight9 optionalposition: 3
includeAutoFilter System.Boolean = true optionalposition: 4
public TableBuilder HasHeader(Boolean hasHeader = true) #
Returns: TableBuilder

Specifies whether the first row of the range is a header row.

Parameters

hasHeader System.Boolean = true optionalposition: 0
public TableBuilder Style(TableStyle style) #
Returns: TableBuilder

Sets the table style to use when adding tables.

Parameters

style OfficeIMO.Excel.TableStyle requiredposition: 0
public TableBuilder WithAutoFilter(Boolean includeAutoFilter = true) #
Returns: TableBuilder

Specifies whether to enable AutoFilter for the table.

Parameters

includeAutoFilter System.Boolean = true optionalposition: 0