Results 1 to 2 of 2

Thread: how could i set the format of an Excel column?

  1. #1
    Join Date
    Apr 2016
    Posts
    1
    Qt products
    Qt5
    Platforms
    Windows

    Default how could i set the format of an Excel column?

    i have a xls file generated from another application. I should modify the xls file when reading it in my QT application, for example, change the type of some columns from number to text.

    could i use QAxObject.setProperty() or dynamicCall()?

    and how to set text type in QT?

  2. #2
    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: how could i set the format of an Excel column?

    could i use QAxObject.setProperty() or dynamicCall()?
    Probably, if you can use Excel's ActiveX interfaces to identify the workbook, sheet, and column you want to modify.

    and how to set text type in QT?
    Using Excel's ActiveX API and whatever parameters that API tells you to use to change the text format. This isn't a Qt issue, it is an Excel issue.

Similar Threads

  1. Replies: 1
    Last Post: 20th November 2015, 10:12
  2. Replies: 1
    Last Post: 30th June 2011, 00:32
  3. Replies: 2
    Last Post: 3rd June 2011, 08:39
  4. Replies: 3
    Last Post: 5th May 2011, 15:03
  5. Replies: 1
    Last Post: 14th January 2011, 12:57

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.