https://forge.codesys.com/forge/talk/CODESYS-V2/thread/6fa3e34301/2020-02-27T20:09:38.852000ZRecent posts to Complete Arrays to Excell via GatewayDDEServer2020-02-27T20:09:38.852000Z2020-02-27T20:09:38.852000Zshooterhttps://forge.codesys.com/u/shooter/https://forge.codesys.com27814dc590b9a6395d679305a1ac7e4bc7d513c6

<div class="markdown_content"><p>in excell it is possible to put the value in to a string. and use that, however impossible to do it dynamiccally this way.<br/> ddeserver does not accept numbers, or changing txt.</p></div>

2020-02-27T20:09:35.138000Z2020-02-27T20:09:35.138000ZAndershttps://forge.codesys.com/u/anders/https://forge.codesys.com8ee440cb1405d50d8de079a428fb1101c43bf2ef

<div class="markdown_content"><p>Hi,</p> <p>This might ba a question for a Excell forum, I do not know, but I hope someone can help me </p> <p>I have a Festo CPX-CEC PLC from which I would like to read values into an excell sheet via CoDeSys GatewayDDEServer, I saw the examples for this at:<br/> <a class="" href="http://www.3s-software.com/index.shtml?sample_projects" rel="nofollow">http://www.3s-software.com/index.shtml?sample_projects</a> </p> <p>And I can make it work fine, what I wonder now is how can I read in an array of lets say 600x4 in an dynamic way (Not writing every command by hand, it is 2400 of them...)</p> <p>The commande below only lets me read part of the array at a time and it is not an Excell command so it does not let me use standard Excell dynamics</p> <p>=GatewayDDEServer|'DDE_Excell_test.pro'!'measurement.StoreArr<span>[2,1]</span>'</p> <p>Do I have to use macros inside Excell or is there som other way?</p> <p>Best regards<br/> Anders</p></div>