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. SQL, export to word
Forum Updated to NodeBB v4.3 + New Features

SQL, export to word

Scheduled Pinned Locked Moved General and Desktop
6 Posts 5 Posters 4.4k 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.
  • B Offline
    B Offline
    bright day
    wrote on last edited by
    #1

    Hi all! In my program, which works with MySQL database, I need to export the result of SQL query to microsoft word. Are there any ways to do this with Qt (or even without, if you know)?

    1 Reply Last reply
    0
    • W Offline
      W Offline
      wagner.reck
      wrote on last edited by
      #2

      You can connect to your database using QSql and export using ActiveQT http://doc.qt.nokia.com/latest/activeqt.html (ActiveX)

      But to do it you need to know the Word ActiveX API and, AFAIK, it only work in MS Windows with MS Work installed

      'I will not buy this record, it's scratch'

      1 Reply Last reply
      0
      • S Offline
        S Offline
        Skyrim
        wrote on last edited by
        #3

        Hi
        I export the data to the Excel by the <ActiveQt>. I believe it can be used for Word.
        If you are interested to see the beginning of "this":http://developer.qt.nokia.com/forums/viewthread/1871/

        1 Reply Last reply
        0
        • A Offline
          A Offline
          andre
          wrote on last edited by
          #4

          All versions of word also support reading .rtf, which is opened by Word by default. That format is much easier to write. Modern versions of Word also support more open, XML based formats. These can also be written directly, or through a library.

          1 Reply Last reply
          0
          • J Offline
            J Offline
            Jupiter
            wrote on last edited by
            #5

            do you know the name of the wordl library andre?

            1 Reply Last reply
            0
            • A Offline
              A Offline
              andre
              wrote on last edited by
              #6

              Not from the top of my head, but I know there is such a library in Calligra Suite, a branch-off of KOffice that can write .odt files. Recent versions of Word can read and write those files.

              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