Results 1 to 6 of 6

Thread: help for reading excel using QT 4.8

  1. #1
    Join Date
    Mar 2013
    Posts
    3
    Qt products
    Qt4
    Platforms
    Windows

    Default help for reading excel using QT 4.8

    hi,
    I am trying to read the excel file by using the QT,some cells in this excel file are composed of check boxes , which I mean one cell have more than one check box in it.
    The problem is I can not find the way to locate the check box.
    I know the way to handle the cell,but I can not locate the check box in that cell.

    Your help in the matter is greatly appreciated.
    --
    Regards,
    Bin.

  2. #2
    Join Date
    Sep 2011
    Posts
    1,241
    Thanks
    3
    Thanked 127 Times in 126 Posts
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: help for reading excel using QT 4.8

    If you have a problem, CUT and PASTE your code. Do not retype or simplify it. Give a COMPLETE and COMPILABLE example of your problem. Otherwise we are all guessing the problem from a fabrication where relevant details are often missing.

  3. #3
    Join Date
    Mar 2013
    Posts
    3
    Qt products
    Qt4
    Platforms
    Windows

    Smile Re: help for reading excel using QT 4.8

    Hi amleto,
    thanks for your reply.My problem is how to find a check box in one cell.Like the image I pasted below.
    未命名.jpg
    In cell of A1:A1, there are two check box,so if I want to handle one of the check boxes,first I should find the check box in A1:A1.The question here is I don't know which function in QT can help me do that.

  4. #4
    Join Date
    Jan 2008
    Location
    Alameda, CA, USA
    Posts
    5,230
    Thanks
    302
    Thanked 864 Times in 851 Posts
    Qt products
    Qt5
    Platforms
    Windows

    Default Re: help for reading excel using QT 4.8

    There isn't any function in Qt that will read a cell from an Excel file and tell you if it has checkboxes in it, and if it does, which ones are checked.

    Excel is not Qt. Just because Excel tables and Qt tables can each contain checkboxes in their cells doesn't mean you can use one tool to read the values from the other.

  5. #5
    Join Date
    Mar 2013
    Posts
    3
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: help for reading excel using QT 4.8

    Well, that's what I got from the webpages ,which tell you how to open and save one excel by QT,but none of them tells you how to search a checkbox in excel.
    QT have the ability to handle the data in cells,like the number and string or something else ,but the control.If it's true, this question is definitely unsolvable.At least I get the reason finally.
    So thanks a lot for your help.
    Last edited by beiji; 2nd April 2013 at 01:23.

  6. #6
    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: help for reading excel using QT 4.8

    If you can access information on the Windows checkbox controls embedded in the Excel cell through the Excel COM API then you should be able to access it from Qt using ActiveQt... otherwise you are out of luck.

Similar Threads

  1. Qt for Excel/VBA
    By Nightfox in forum Qt Programming
    Replies: 9
    Last Post: 13th December 2012, 11:39
  2. Replies: 1
    Last Post: 29th June 2012, 12:38
  3. Qt and Excel
    By eltecprogetti in forum Qt Programming
    Replies: 7
    Last Post: 13th March 2012, 12:04
  4. Excel and Qt
    By antialias in forum Qt Programming
    Replies: 10
    Last Post: 29th October 2011, 11:42
  5. Excel using Qt
    By nmn in forum Qt Programming
    Replies: 3
    Last Post: 28th July 2007, 02:44

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.