Results 1 to 2 of 2

Thread: Insert Column into Excel Spreadsheet

  1. #1
    Join Date
    Oct 2020
    Qt products
    MacOS X Unix/X11 Windows

    Default Insert Column into Excel Spreadsheet

    There doesn't seem to be a way to insert a column (or row) into an excel spreadsheet using the QXLSX library. I feel like it should be simple, am I missing something? The Document class has methods for inserting images, charts, sheets, but not rows and columns?!?!

    Thanks in advance.

  2. #2
    Join Date
    Mar 2009
    Brisbane, Australia
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Unix/X11 Windows
    Wiki edits

    Default Re: Insert Column into Excel Spreadsheet

    A row or column is not part of a workbook/document in Excel, so it is not overly surprising that these function are "missing" in this third party library's document class. I have never used this library and I cannot see an obvious way to do what you ask. I would have expected something in the Worksheet class, or maybe CellRange. The support seems very much tied to the concrete representation in XML.

    If you are developing for Windows you can use the Excel object interface through ActiveQt to gain complete Excel capability (at the cost of having Excel installed).

Similar Threads

  1. how could i set the format of an Excel column?
    By sesamfox in forum Qt Programming
    Replies: 1
    Last Post: 11th April 2016, 18:10
  2. Qtableview insert row and column
    By maarvi in forum Newbie
    Replies: 1
    Last Post: 1st July 2011, 09:26
  3. Replies: 1
    Last Post: 29th June 2011, 23:32
  4. Insert into array column
    By wirasto in forum Newbie
    Replies: 3
    Last Post: 9th November 2009, 15:07
  5. QTreeView like excel spreadsheet
    By Stapl in forum Qt Programming
    Replies: 3
    Last Post: 18th September 2009, 10:13

Tags for this Thread


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.