Difference between revisions of "XL3DoWriteback2"
| Line 13: | Line 13: | ||
| {{Code|PerformWriteback}} | | {{Code|PerformWriteback}} | ||
| A reference to a range containing a boolean value ({{TRUE}} or {{FALSE}}) specifying whether to actually perform the writeback. That cell's value will be reset to {{FALSE}} following the writeback operation | | A reference to a range containing a boolean value ({{TRUE}} or {{FALSE}}) specifying whether to actually perform the writeback. That cell's value will be reset to {{FALSE}} following the writeback operation | ||
| + | |- | ||
| + | | {{Code|IntitialValue}} | ||
| + | | The current value stored in Anaplan for that cell. Typically this is read from an AnaplanXL grid. | ||
|- | |- | ||
| {{Code|WriteValue}} | | {{Code|WriteValue}} | ||
Revision as of 15:37, 30 October 2024
XL3DoWriteback2 works similary to XL3DoWriteback but is used instead to input data to Anaplan and takes the additional "InitialValue" argument.
Syntax
XL3DoWriteback2( PerformWriteback, IntitialValue, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| Parameter | Description |
|---|---|
| PerformWriteback | A reference to a range containing a boolean value (TRUE or FALSE) specifying whether to actually perform the writeback. That cell's value will be reset to FALSE following the writeback operation |
| IntitialValue | The current value stored in Anaplan for that cell. Typically this is read from an AnaplanXL grid. |
| WriteValue | The value to be written. Typically an Excel cell reference. |
| Connection | Connection number to use |
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the following member applies to e.g. "Measures" or "[Customer].[Customer Geography]" |
| Member1,…, MemberN | Either a single member unique name or an XL3Member formula |
