Results 1 to 3 of 3

Thread: How to export data in tableview to an excel file?

  1. #1
    Join Date
    Nov 2013
    Posts
    11
    Thanks
    2
    Qt products
    Qt4
    Platforms
    Windows

    Question How to export data in tableview to an excel file?

    Hello,there!
    Now I am doing a project in which a QTableView is used to display the parsed data,and we have already finished this part.Then we want to export the data in table into an excel file.We use "QAxObject("Excel.Application", parent)" to call the excel application in a new thread,but the code just doesn't work.We could not figure out why.Could anyone here help us with this problem,please? I would add the code here if you need.

  2. #2
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: How to export data in tableview to an excel file?

    We use "QAxObject("Excel.Application", parent)" to call the excel application in a new thread,but the code just doesn't work.
    There is almost certainly no need for a thread and almost no information that would help us help you.

    What does "doesn't work" mean?
    What did you see and what did you expect?
    What have you done to diagnose the problem?
    What error messages or return codes do you have?

  3. The following user says thank you to ChrisW67 for this useful post:

    drunknight (31st December 2013)

  4. #3
    Join Date
    Nov 2013
    Posts
    11
    Thanks
    2
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: How to export data in tableview to an excel file?

    Doesn't work means that the UI was stuck when I started exporting.Firstly we thought that maybe we used the thread in the wrong way,and now we consider that Qthread and "QAxObject("Excel.Application", parent)" are not compatible.Then we change our strategy by using ODBC. Fortunately it works!
    Thank you all the same!: )

Similar Threads

  1. Replies: 16
    Last Post: 28th April 2020, 14:40
  2. Replies: 0
    Last Post: 29th September 2011, 08:32
  3. Trying to export to Excel
    By ShamusVW in forum Qt Programming
    Replies: 7
    Last Post: 4th August 2010, 08:07
  4. how to export data to a .CSV file
    By qtprgrmr in forum Qt Programming
    Replies: 1
    Last Post: 26th May 2010, 16:22
  5. Replies: 3
    Last Post: 12th June 2008, 11:59

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.