ISectionBuilder

Defines the public contract for the SectionBuilder class, exposing a single Build method that iterates dictionary rows for a given sheet, groups them into sections and subsections, writes all variables via VarWriter, and applies section and subsection header formatting. The active mode (HList or VList) controls layout direction and companion sheet handling. Building modes control layout direction. HList builds horizontally on the main sheet plus printed and CRF companions. VList builds vertically on the main sheet only.

Methods

Build #

Build all sections, subsections, and variables for a sheet

Signature:

Public Sub Build(ByVal sheetName As String, ByVal startRow As Long)

Scans the dictionary for rows matching sheetName starting from startRow, then iterates through sections and subsections, writing each variable via VarWriter and applying merged-cell section and subsection header formatting. For HList mode, headers appear on the main, printed, and CRF companion worksheets. For VList mode, headers appear on the main sheet only.

Parameters:

  • sheetName: String. The sheet name as it appears in the dictionary "sheet name" column.
  • startRow: Long. The first data row index in the dictionary for this sheet (1-based).