OMRON
APPENDIX F – Obsolete Features
Release 2.0
Page 317
1) Example CX-Supervisor Script demonstrating client array points
chan = DDEInitiate(“Excel”, “Book1.xls”)
IF chan > 0 THEN
‘Establish data transfers between point ‘DDEArray’ and Excel
‘the initial values of DDEArray is sent to Excel
DDEOpenLinks(chan)
‘The array is initialised with the value 5 and sent to Excel in
one
operation.
InitArray(DDEArray, 5)
‘The contents of ‘MemoryArray’ are copied into ‘DDEArray’ and the
‘array are sent to Excel in one operation.
MemoryArray[0] = 100
MemoryArray[1] = 34
MemoryArray[2] = 89 * 6
CopyArray(MemoryArray, DDEArray)
‘Sets element 2 of the array to 6 and sends the whole array to
Excel
‘Note: Use ‘On Request’ option and ‘OutputPoint’ to send the array
‘after ‘setting several elements of a large array.
DDEArray[2] = 6
ENDIF
DDE Script Functions
The existing DDE Script functions DDEPoke() and DDERequest() can be used with any array points
as the following example CX-Supervisor Scripts show:
1) Example CX-Supervisor Script demonstrating DDEPoke() with arrays
chan = DDEInitiate(“Excel”, “Book1:Sheet2”)
IF chan > 0 THEN
‘Send element 1 of ‘RealArray’ to Excel
DDEPoke(chan, "R16C1", RealArray[1])
‘Send IntegerArray to Excel as a column (note: range and column
must
‘be
‘specified)
DDEPoke(chan, "R1C1:R3C1[column]", IntegerArray)
‘Send TextArray to Excel as a row (default only range required)
DDEPoke(chan, "R1C2:R1C4", TextArray)
ENDIF
Summary of Contents for CX-SUPERVISOR - V2.0
Page 2: ...CX Supervisor User Manual Software Release 2 0...
Page 3: ......
Page 5: ...CX Supervisor User Manual OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor User Manual OMRON Page iv Revision 2 0...
Page 11: ...CX Supervisor User Manual OMRON Page viii Revision 2 0...
Page 13: ...CX Supervisor User Manual OMRON Page x Revision 2 0...
Page 15: ...CX Supervisor User Manual OMRON Page xii Revision 2 0...
Page 17: ...CX Supervisor User Manual OMRON Page xiv Revision 2 0...
Page 19: ...CX Supervisor User Manual OMRON Page xvi Revision 2 0...
Page 21: ...CX Supervisor User Manual OMRON Page xviii Revision 2 0...
Page 23: ......
Page 67: ......
Page 97: ......
Page 137: ...CHAPTER 7 Graphics Library OMRON Page 114 Release 2 0...
Page 183: ...CHAPTER 9 Animation OMRON Page 160 Release 2 0...
Page 215: ......
Page 263: ......
Page 269: ......
Page 274: ...OMRON CHAPTER 16 Connecting to Omron Industrial Components Release 2 0 Page 251...
Page 275: ......
Page 285: ......
Page 319: ......
Page 331: ......
Page 351: ......
Page 359: ...GLOSSARY OF TERMS CX Supervisor User Manual OMRON Page 336 Release 2 0...