Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. How to get DDE data?
Forum Updated to NodeBB v4.3 + New Features

How to get DDE data?

Scheduled Pinned Locked Moved General and Desktop
8 Posts 3 Posters 5.7k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    RomanShteff
    wrote on last edited by
    #1

    Hi everyone! There is an application that transmits data via DDE to Excel spreadsheet. I need this data in my Qt application. Is there a solution how to get data directly from the application, rather than from a Excel. Is it possible to solve this problem by using QAxObject?

    1 Reply Last reply
    0
    • R Offline
      R Offline
      RomanShteff
      wrote on last edited by
      #2

      Any ideas?

      1 Reply Last reply
      0
      • G Offline
        G Offline
        goetz
        wrote on last edited by
        #3

        You should give people a bit more time than 4 hours to comment on your problem. Thank you.

        http://www.catb.org/~esr/faqs/smart-questions.html

        1 Reply Last reply
        0
        • G Offline
          G Offline
          giesbert
          wrote on last edited by
          #4

          Afaik DDE on windows is event based. I have no experience with it, but you can catch DDE events like all windows events ("winEvent()":http://doc.qt.nokia.com/4.7/qwidget.html#winEvent ?!).

          On the other hand, it depends on the application if you can get the data directly. DDE is a point to point protocoll (Direct Data Exchange) that is based on windows events. So how would you intercept it?

          So first of all you need to know the interface of the data server application. Or you have to read it from excel.

          Nokia Certified Qt Specialist.
          Programming Is Like Sex: One mistake and you have to support it for the rest of your life. (Michael Sinz)

          1 Reply Last reply
          0
          • R Offline
            R Offline
            RomanShteff
            wrote on last edited by
            #5

            to Gerolf:

            I tried to read it from Excel and I read the value from cell but the value is constantly updated so I can't refresh it in my lineEdit item. Data server application uses DDE format ("Server|Topic!Item").

            1 Reply Last reply
            0
            • G Offline
              G Offline
              giesbert
              wrote on last edited by
              #6

              But the server send to excel, right?
              Otherwise connect yourself to the DDE events and read them.

              Nokia Certified Qt Specialist.
              Programming Is Like Sex: One mistake and you have to support it for the rest of your life. (Michael Sinz)

              1 Reply Last reply
              0
              • R Offline
                R Offline
                RomanShteff
                wrote on last edited by
                #7

                to Gerolf:

                Thanks for your reply!

                Right, the server send data to excel. So how can I connect to the DDE events? With QAxObject?

                1 Reply Last reply
                0
                • G Offline
                  G Offline
                  giesbert
                  wrote on last edited by
                  #8

                  If the server always send data to excel, you can't.

                  its a point to point connection. the only thing would be a man in the middle attack, which is not what you want, I'm pretty sure :-)

                  QAxObject is COM, not DDE. The DDE sink is Excel, not your application. Try to connect to the server app via DDE if that is possible, otherwise I have no idea how to intercept events from DDE.

                  Nokia Certified Qt Specialist.
                  Programming Is Like Sex: One mistake and you have to support it for the rest of your life. (Michael Sinz)

                  1 Reply Last reply
                  0

                  • Login

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • Users
                  • Groups
                  • Search
                  • Get Qt Extensions
                  • Unsolved