API Reference
Class
ExcelTableBuilder
Fluent helpers for adding Excel tables over a range.
Inheritance
- Object
- ExcelTableBuilder
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Method ExcelTableBuilder.Add
- Method ExcelTableBuilder.HasHeader
- Method ExcelTableBuilder.Style
- Method ExcelTableBuilder.WithAutoFilter
Accepted by parameters
- Method SheetBuilder.Table
- Method SheetBuilder.Table
Methods
public ExcelTableBuilder Add(String range, Boolean hasHeader = true, String name = "", ExcelTableStyle style = TableStyleLight9, Boolean includeAutoFilter = true) #Returns:
ExcelTableBuilderAdds a table over the specified A1 range with optional header, name, style and AutoFilter.
Parameters
- range System.String
- hasHeader System.Boolean = true
- name System.String = ""
- style OfficeIMO.Excel.ExcelTableStyle = TableStyleLight9
- includeAutoFilter System.Boolean = true
public ExcelTableBuilder HasHeader(Boolean hasHeader = true) #Returns:
ExcelTableBuilderSpecifies whether the first row of the range is a header row.
Parameters
- hasHeader System.Boolean = true
public ExcelTableBuilder Style(ExcelTableStyle style) #Returns:
ExcelTableBuilderSets the table style to use when adding tables.
Parameters
- style OfficeIMO.Excel.ExcelTableStyle
public ExcelTableBuilder WithAutoFilter(Boolean includeAutoFilter = true) #Returns:
ExcelTableBuilderSpecifies whether to enable AutoFilter for the table.
Parameters
- includeAutoFilter System.Boolean = true
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object