Showing results 1 to 3 of 3

Thread: Reading Values with the DDE-Driver from Excel

  1. #1
    Join Date
    08.05.2019
    Posts
    2

    Default Reading Values with the DDE-Driver from Excel

    Hi!
    I am trying to read a column from an Excel-table into an array in zenon. In order to do that I created a DDE-Client-driver and a DDE-variable.
    Name: EXCEL_Value
    Server: EXCEL
    Topic: [AUFTRAG.XLSX]SHEET1
    Item: R1C1:R8C1

    Then I imported the variable from the driver as an SPS Memory Object and String as Datatype. When I try to display the value of the variable in the runtime with the dynamic text element - nothing gets displayed. (I also tried to display a singel cell with Item:R1C1, but I also got no value displayed in zenon).

    If I import my DDE-Driver settings in Excel I can however write values from zenon to Excel. But as stated before, reading values does not work for me.

    I hope you can help me with!

  2. #2
    Join Date
    01.07.2008
    Location
    Salzburg, AT
    Posts
    810

    Default Re: Reading Values with the DDE-Driver from Excel

    maybe your dynamic text element is configured to display the variable "limit value text" and not the value?

  3. #3
    Join Date
    08.05.2019
    Posts
    2

    Default Re: Reading Values with the DDE-Driver from Excel

    No it's configured to display the Variable value.
    I just saw, that Copa-Data developed an Excel-macro for variable import. Is it possible to share this file with me?

Similar Threads

  1. Need help: Create driver variable from an excel rows sheet
    By marcomauri in forum zenon Energy Edition
    Replies: 1
    Last Post: 31st January 2019, 04:59
  2. Updating Values of variables in Scada from Excel
    By jonastj in forum zenon Supervisor
    Replies: 1
    Last Post: 3rd February 2015, 14:35
  3. Status: INVALID , NT_870 but reading values
    By geleto021 in forum zenon Energy Edition
    Replies: 1
    Last Post: 1st April 2014, 09:46
  4. Updating Values from Scada to Excel
    By sidramsatyal in forum zenon Supervisor
    Replies: 2
    Last Post: 10th January 2014, 18:49
  5. Reading Excel
    By navaneet in forum zenon Supervisor
    Replies: 1
    Last Post: 27th September 2013, 17:09

Tags for this Thread

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •