Introduction to the DeltaV Excel Add-in
DVWrite Notes
- In order to execute a write
function, you must specifically choose to execute and confirm the write. A Write function will only execute when you select Execute Write Function from . This makes
write functions unlike the read functions in two ways:
- the update interval does
not provide automated execution of write functions
- when you create or edit
a write function, the function will not execute. The software returns the
message, "DVWrite Disabled".
- When the active cell in the
spreadsheet is empty, selecting Execute Write Function causes all of the DVWrite
functions on the active worksheet to execute. DVWrite functions in other
worksheets do not execute.
- When one or more functions
are selected, clicking Execute Write Function executes only those functions. The
selected cells must be contiguous.
- Only functions on the active
worksheet can be executed.
- If MS Excel's calculation
mode is manual when DVWrites are executed, the DVWrite functions will show "0" or
"success" if they succeeded and the error code or corresponding string if they
did not.
- If MS Excel's calculation
mode is automatic when you select
Execute Write Function, the software
temporarily changes the mode to manual in order to execute the function and
send the value. If any function fails to write successfully, the software
displays the number of errors and asks you if you want to restore the
calculation mode to automatic. You must select
No if you want to examine the error values. If
you select
Yes, the software changes the mode back to
automatic which fills the write function cells with a value of "DVWrite
disabled". If all write functions succeed, the software changes the node back
to automatic which replaces "success" or "0" in the write function cells with
"DVWrite disabled".
- If you use the
Configure Write Function dialogs to specify the
parameter property, the parameter reference is in uppercase. If you enter the function manually, you must
enter the parameter reference in uppercase.