API Reference
ColumnComposer
Column-scoped composer used by [[cref:OfficeIMO.Excel.Fluent.SheetComposer.ColumnComposer.Columns(System.Int32,System.Action{OfficeIMO.Excel.Fluent.SheetComposer.ColumnComposer[]},System.Int32,System.Int32,OfficeIMO.Excel.Fluent.OverflowMode)]] to write simple sections into a single column while keeping track of vertical position.
Inheritance
- Object
- ColumnComposer
Methods
public ColumnComposer BulletedList(IEnumerable<String> items) #ColumnComposerWrites a bullet for each item (• text) in this column.
Parameters
- items System.Collections.Generic.IEnumerable{System.String}
public ColumnComposer Columns(Int32 count, Action<ColumnComposer[]> configure, Int32 columnWidth = 3, Int32 gutter = 1, OverflowMode overflow = Throw) #ColumnComposerSplits the current column region into horizontal sub-columns, rendering each via a nested ColumnComposer. Advances the parent column by the tallest child block and applies a spacer afterwards.
Parameters
- count System.Int32
- Number of sub-columns to create.
- configure System.Action{OfficeIMO.Excel.Fluent.SheetComposer.ColumnComposer[]}
- Callback receiving the nested ColumnComposer instances.
- columnWidth System.Int32 = 3
- Width per sub-column in grid columns.
- gutter System.Int32 = 1
- Spacing between sub-columns in grid columns.
- overflow OfficeIMO.Excel.Fluent.OverflowMode = Throw
- Specifies how content that exceeds the allocated width should be handled.
public ColumnComposer KeyValue(String key, Object value) #ColumnComposerWrites a two-column key/value row with styled key cell.
Parameters
- key System.String
- value System.Object
public ColumnComposer KeyValues(IEnumerable<ValueTuple<String, Object>> pairs) #ColumnComposerWrites multiple key/value rows in order.
Parameters
- pairs System.Collections.Generic.IEnumerable{System.ValueTuple{System.String,System.Object}}
public ColumnComposer Paragraph(String text) #ColumnComposerWrites a single paragraph cell and advances the row.
Parameters
- text System.String
public ColumnComposer Section(String text) #ColumnComposerWrites a section header cell using the current theme's section style.
Parameters
- text System.String
public ColumnComposer Spacer(Int32 rows = 1) #ColumnComposerAdds vertical space.
Parameters
- rows System.Int32 = 1
- Number of rows to skip (minimum 1).
public String TableFrom<T>(IEnumerable<T> items, String title = null, Action<ObjectFlattenerOptions> configure = null, TableStyle style = TableStyleMedium9, Boolean autoFilter = true, Action<TableVisualOptions> visuals = null) #StringType Parameters
- T
Parameters
- items IEnumerable<T>
- title String = null
- configure Action<ObjectFlattenerOptions> = null
- style TableStyle = TableStyleMedium9
- autoFilter Boolean = true
- visuals Action<TableVisualOptions> = null
TableFrom``1(System.Collections.Generic.IEnumerable{``0} items, System.String title, System.Action{OfficeIMO.Excel.ObjectFlattenerOptions} configure, OfficeIMO.Excel.TableStyle style, System.Boolean autoFilter, System.Action{OfficeIMO.Excel.Fluent.TableVisualOptions} visuals) #Renders a table inside this column starting at the current row and returns the A1 range. This variant avoids freezing panes to prevent conflicts when multiple tables are placed per sheet.
Parameters
- items System.Collections.Generic.IEnumerable{``0}
- title System.String
- configure System.Action{OfficeIMO.Excel.ObjectFlattenerOptions}
- style OfficeIMO.Excel.TableStyle
- autoFilter System.Boolean
- visuals System.Action{OfficeIMO.Excel.Fluent.TableVisualOptions}
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object