IOverhead.FillMacroColumn Method

Pushes data to a macro column in a list sheet or a set-of-field sheet in the overhead workbook.
Sub FillMacroColumn( _ 
ByVal sheetId As String, _ 
ByVal macroColumnId As String, _ 
Optional ByVal dataForCore As Dictionary(Of String, Object) = Nothing, _ 
Optional ByVal dataForOverheadMinute As Dictionary(Of String, Object) = Nothing, _ 
Optional ByVal dataForOptions As Dictionary(Of String, Object) = Nothing _ 
)
This language is not supported or no code example is available.
void FillMacroColumn( 
string sheetId
string macroColumnId
Dictionary<string, object> dataForCore = Nothing, 
Dictionary<string, object> dataForOverheadMinute = Nothing, 
Dictionary<string, object> dataForOptions = Nothing 
)
This language is not supported or no code example is available.

Parameters

sheetId
string

The identifier (Mnemonic) of the field or the set of field in which the data is broken down in the overhead, E.g.: MATERIAL, WORKFORCE, MATTER...

macroColumnId
string

The identifier of the macro column to be fed as defined when you edit the column.

dataForCore
Dictionary<string, object>

A dictionary whose keys are the IDs in the sheet and values are the values in the targeted column of the sheet, a blank ID feeds the first row "Not Mentioned". This will feed the Core area of the sheet.

dataForOverheadMinute
Dictionary<string, object>

A dictionary whose keys are the IDs in the sheet and values are the values in the targeted column of the sheet, a blank ID feeds the first row "Not Mentioned". This will feed the Overhead-Minute area of the sheet.

dataForOptions
Dictionary<string, object>

A dictionary whose keys are the IDs in the sheet and values are the values in the targeted column of the sheet, a blank ID feeds the first row "Not Mentioned". This will feed the Optional area of the sheet.

Exception type Condition

ArgumentException

The sheetId or macroColumnId contain an empty string.

All three data arguments are set to null reference (Nothing in Visual Basic): dataForCore, dataForOverheadMinute and dataForOptions. You must provide at least one dictionary.

QdvApiException

A problem occurred.

ArgumentNullException

Some missing parameters.

Remarks
 
All figures are deleted in the column for the given area before new figures are pushed. So, when you want to empty the column, just provide blank dictionaries.
Version
 
Available since QDV 7.22.995.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition