IVarWriter
Defines the public contract for the VarWriter class, exposing methods for writing a single dictionary variable to one or more linelist worksheets and for reading dictionary column values. Consumers call WriteVariable once per variable; the implementation handles main, printed-companion, and CRF-companion sheets according to the active layer (HList or VList). Layers control which worksheets are written. HList writes to the main sheet plus optional printed and CRF companions. VList writes to the main sheet only.
Methods
WriteVariable #
Write one variable to the target worksheet(s)
Signature:
Public Sub WriteVariable(ByVal varName As String)
Writes label, formula, type formatting, choices, validation, and conditional formatting for the named variable. On HList layers the method also writes to the printed and CRF companion sheets when they are available. Internally resets cached cell ranges before each invocation so the writer can be reused across multiple variables.
Parameters:
varName: String. The variable name as it appears in the dictionary.
ValueOf #
Read a dictionary column value for the current variable
Signature:
Public Property Get ValueOf(ByVal colName As String) As String
Returns the value stored in the specified dictionary column for the variable that was most recently passed to WriteVariable. Delegates to LLVariables.Value internally.
Parameters:
colName: String. The dictionary column name to look up.
Returns: String. The column value for the current variable.