Get data from a Dynamic Data Exchange (DDE) server, PC Windows only (D.B. Baird).
|Controls whether a catalogue of the structures read from the DDE server is printed (
||Whether to display the spreadsheet within the windows interface (
||How identifiers are specified for the columns (
||Name of DDE Server (ignored if
||Name of DDE Topic|
||Name of DDE Item|
||Name of a previously saved Genstat DDE link file|
||Names and/or type codes for the columns read (the type of column can be forced by ending the column name, if supplied, with the code
||Name of a pointer to save the column identifiers|
A DDE server is another windows program (e.g. Microsoft Excel) that will supply data on a DDE request. The data to be read via DDE is specified by the DDE triplet: server, topic and item. Alternatively the name of an existing GDE file containing these can be specified using the
GDEFILE parameter. GDE files can be created by opening a spreadsheet with the Spread > New > from DDE Link menu item, and then saving the resulting spreadsheet with the file type Genstat DDE Link (*.GDE).
TOPIC for Excel has the format
Summary', and the
ITEM has the numerical format
'R2C3:R25C5' or the format
TOPIC for QPW has the format
'D:/Work/Data.WB3', and the
ITEM has the format of
COLUMNS parameter can be used to set the names of the structures. It can also be used to force the type of column by ending the column name with the code
! for a variate,
# for a variate, and
$ for a text. For example
will create a factor called
Trt, a text called
ID and a variate called
Rank. If only the type code is provided, the columns will not be renamed, but the new types will set, e.g.
will force the first three columns to be of type factor, variate and text respectively.
DDEIMPORT replaces the procedure
DDELOAD from earlier editions of Genstat.)
The DDE server is queried with the
ITEM, and any data received from the DDE server is sent to a temporary GSH file which is read in with the
Restrictions are not applicable to any of the parameters.
Commands for: Input and output.