Results 1 to 3 of 3

Thread: Multiplatform "excel" generation

  1. #1
    Join Date
    Jul 2006
    Location
    Catalunya - Spain
    Posts
    117
    Thanks
    16
    Thanked 8 Times in 8 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Multiplatform "excel" generation

    Hi all,

    First, I know this is not a Qt Programming question strictly speaking, but is related to a need I have with Qt.

    In the past I wrote a very simple Excel file generator ( in XML ). Now I'm trying to do something I can't find anywhere on the web.

    I've to export my application on-screen tables & trees to excel files to allow users to manipulate data externally from the ERP I'm developing. I don't want to use excel nor QAx, because it must work on Windows / Linux.

    Until now I've tried two options :

    - Generate Excel's XML format ( slow for large files and undocumented ). Also OpenOffice cannot load those files.

    - xlslib ( a 3rd party library I've found, not complete & generates Excel 95 files, that are size-limited )

    None of them is good enough for me, as you can see...

    The best option for me should be generate OpenOffice "calc" files, so :

    - File format is an open & known format
    - Works on Linux & New versions of MS Office versions.

    And my questions :

    Someone knows where I can found a simple C++ API documentation for OpenOffice ? The one I've found in openoffice's site is big and very complex...

    - Trolltech or any partner has interest in develop an "OpenOffice link" inside Qt's library ? Qt can generate PDF files, why not generate an open format like OpenOffice's odt / ods ...

    - Somebody knows a better alternative than the one I'm proposing ? Suggestions accepted...

    Many thanks

    Jordi

  2. #2
    Join Date
    Oct 2006
    Posts
    279
    Thanks
    6
    Thanked 40 Times in 39 Posts
    Qt products
    Qt4
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Multiplatform "excel" generation

    Quote Originally Posted by jpujolf View Post
    - Somebody knows a better alternative than the one I'm proposing ? Suggestions accepted...
    How about just generating a comma separated file(*.csv)? It's very simple to generate and most applications can read it.

  3. #3
    Join Date
    Jul 2006
    Location
    Catalunya - Spain
    Posts
    117
    Thanks
    16
    Thanked 8 Times in 8 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Multiplatform "excel" generation

    Oh yes !! I never thought that !!

    Sorry for the ironic comment, but... Of course, I've a simple CSV export, but my users want EVERYTHING : colors, cell merge, embedded images, formulas, ...

    By now CSV is my actual "big volume working" solution, but forces the final user to import to the spreadsheet program, format the output, etc...

    Anyway, thanks for the answer

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
  •  
Qt is a trademark of The Qt Company.