DDEPOKE

Purpose:

Sends data to a DDE conversation in string form.

DDEPOKE(chan, "item", data)

chan	-	An integer, the DDE channel number returned by DDEINITIATE.
"item"	-	A string, the item of the data destination.
data	-	A string, scalar or series representing the data to send.

A 1 if successful; otherwise it returns 0 indicating an error.

chan = ddeinit("Excel", "Sheet1")

ddepoke(chan, "R1C1", 12.7)

ddeterm(chan)

establishes a DDE conversation with Excel, sends the value 12.7 as a string to the cell in row 1, column 1 and then terminates the conversation.

ddepoke(chan, "R1C1:R100C1", W1*10)

sends the entire series of W1*10 as a CR-LF delimited string to the cells in row 1 column 1 through row 100 column 1.

DDEPOKE always converts the data into an appropriate string format.