Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. General talk
  3. Brainstorm
  4. Excel API for C/C++
Forum Updated to NodeBB v4.3 + New Features

Excel API for C/C++

Scheduled Pinned Locked Moved Brainstorm
43 Posts 16 Posters 81.1k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • X Offline
    X Offline
    xsacha
    wrote on last edited by
    #10

    Alright, I guess since it is for paying customers it is best to treat them nice.

    Good luck with your Excel API. I'm sure someone has written something like it for Qt somewhere. You checked Qt-Apps already and similar sites?

    This can search Excel files: http://qt-apps.org/content/show.php/recoll?content=66138
    But might not have the full API.

    • Sacha
    1 Reply Last reply
    0
    • G Offline
      G Offline
      goetz
      wrote on last edited by
      #11

      I've searched around with google, got some things that might be interesting, but nothing with using Qt in the first search results. It's not on a very high priority at the moment, so no need to worry. I thought it's worth a try in this forum - if you don't ask, you won't get an answer...

      http://www.catb.org/~esr/faqs/smart-questions.html

      1 Reply Last reply
      0
      • Y Offline
        Y Offline
        Yash
        wrote on last edited by
        #12

        There are 2 C++ libaries to create excel.
        One is free xlslib : http://xlslib.sourceforge.net/
        Other is commercial libXL : http://www.libxl.com/

        Sorry for late response and I don't know whether you need this or not. But for others I share...

        http://kineticwing.com : Web IDE, QSS Editor
        http://speedovation.com : Development Lab

        1 Reply Last reply
        0
        • G Offline
          G Offline
          goetz
          wrote on last edited by
          #13

          Thanks for the links. libxl I will have a look into. xlslib unfortunately cannot read XLS files. This is the crucial part. Writing the files could be quite easily approached with the new XML based format (thats seems not too complicated as long as there are no formulas or cross references, which we do not need).

          http://www.catb.org/~esr/faqs/smart-questions.html

          1 Reply Last reply
          0
          • Q Offline
            Q Offline
            qtrahul
            wrote on last edited by
            #14

            Another available option is to attempt to extract the code from an open source excel reading competitor.

            Open Office - http://www.openoffice.org/ - is likely to be used,

            Gnumeric is probably a better option.
            Excel code is here - http://git.gnome.org/browse/gnumeric/tree/plugins/excel

            1 Reply Last reply
            0
            • Y Offline
              Y Offline
              Yash
              wrote on last edited by
              #15

              Libxls
              libxls is a C library which can read Excel (xls) files. It has been tested on Linux x86 and Cygwin but may work on any little-endian system. ...
              "libxls.sourceforge.net":http://libxls.sourceforge.net

              [EDIT: clickable link, Volker]

              http://kineticwing.com : Web IDE, QSS Editor
              http://speedovation.com : Development Lab

              1 Reply Last reply
              0
              • G Offline
                G Offline
                goetz
                wrote on last edited by
                #16

                Thanks for the link Yash, it looks promising. It could be a good start and maybe I find some time to make a Qt version.

                http://www.catb.org/~esr/faqs/smart-questions.html

                1 Reply Last reply
                0
                • P Offline
                  P Offline
                  Panke
                  wrote on last edited by
                  #17

                  What's about KOffice? As far as I know they use MS -> OOo -> KOffice, but they might have a cuter API to the OOo routines since they are Qt-based.

                  1 Reply Last reply
                  0
                  • G Offline
                    G Offline
                    goetz
                    wrote on last edited by
                    #18

                    KOffice falls out due to license issues - unfortunately.

                    http://www.catb.org/~esr/faqs/smart-questions.html

                    1 Reply Last reply
                    0
                    • F Offline
                      F Offline
                      fcrochik
                      wrote on last edited by
                      #19

                      [quote author="Yash" date="1293597766"]Libxls
                      [EDIT: clickable link, Volker][/quote]
                      Not yet....

                      "libxls.sourceforge.net":http://libxls.sourceforge.net

                      Certified Specialist & Qt Ambassador <a href="http://www.crochik.com">Maemo, Meego, Symbian, Playbook, RaspberryPi, Desktop... Qt everywhere!</a>

                      1 Reply Last reply
                      0
                      • G Offline
                        G Offline
                        goetz
                        wrote on last edited by
                        #20

                        Thanks - corrected * 2 :-)

                        http://www.catb.org/~esr/faqs/smart-questions.html

                        1 Reply Last reply
                        0
                        • F Offline
                          F Offline
                          fcrochik
                          wrote on last edited by
                          #21

                          Has anybody figured out what kind of license is? GPL, LGPL, ... ?

                          I would like to include all the "open source" tools/libraries we talk about into wikis so when needed one can find them in one place.

                          EDIT: What are the KOffice license issues?

                          Certified Specialist & Qt Ambassador <a href="http://www.crochik.com">Maemo, Meego, Symbian, Playbook, RaspberryPi, Desktop... Qt everywhere!</a>

                          1 Reply Last reply
                          0
                          • G Offline
                            G Offline
                            goetz
                            wrote on last edited by
                            #22

                            From http://www.koffice.org/contribute/:

                            bq. KOffice is released under the LGPL v2+ (and GPL v2+ for some parts).

                            http://www.catb.org/~esr/faqs/smart-questions.html

                            1 Reply Last reply
                            0
                            • F Offline
                              F Offline
                              fcrochik
                              wrote on last edited by
                              #23

                              [quote author="Volker" date="1294273445"]From http://www.koffice.org/contribute/:

                              bq. KOffice is released under the LGPL v2+ (and GPL v2+ for some parts).[/quote]

                              Why was that a problem then? Can't get much more flexible than that (unles you are looking for the one part that is only GPL and you want to release a closed source app).

                              EDIT: before I get screamed at: warning: I don't have any idea of the details about "v2+"

                              Certified Specialist & Qt Ambassador <a href="http://www.crochik.com">Maemo, Meego, Symbian, Playbook, RaspberryPi, Desktop... Qt everywhere!</a>

                              1 Reply Last reply
                              0
                              • G Offline
                                G Offline
                                goetz
                                wrote on last edited by
                                #24

                                I'd have to extract the parts I need, remove the KDE stuff (not available on Windows and Mac) and publish it as a new LGPL project. We do not have the time for that at the moment and it's not on top of the want-have list of the customer.

                                http://www.catb.org/~esr/faqs/smart-questions.html

                                1 Reply Last reply
                                0
                                • F Offline
                                  F Offline
                                  fcrochik
                                  wrote on last edited by
                                  #25

                                  I see.... so the issue is not exactly with the license...

                                  Certified Specialist & Qt Ambassador <a href="http://www.crochik.com">Maemo, Meego, Symbian, Playbook, RaspberryPi, Desktop... Qt everywhere!</a>

                                  1 Reply Last reply
                                  0
                                  • G Offline
                                    G Offline
                                    goetz
                                    wrote on last edited by
                                    #26

                                    The license is one of the issues. Nevermind, I have some hints I will dig into further if I ever have some spare time.

                                    http://www.catb.org/~esr/faqs/smart-questions.html

                                    1 Reply Last reply
                                    0
                                    • K Offline
                                      K Offline
                                      kunashir
                                      wrote on last edited by
                                      #27

                                      Volker, as your successes with excel?
                                      I use libxls, but some excel's files in russian language not read correctly (I realized because of the inability to convert data from a file in UTF-16). If you have any achievements, can you tell us about them?

                                      1 Reply Last reply
                                      0
                                      • G Offline
                                        G Offline
                                        goetz
                                        wrote on last edited by
                                        #28

                                        I did not look into libxls yet, so sorry, no advice from my side.

                                        http://www.catb.org/~esr/faqs/smart-questions.html

                                        1 Reply Last reply
                                        0
                                        • J Offline
                                          J Offline
                                          Jupiter
                                          wrote on last edited by
                                          #29

                                          is there also something for word documents (*.doc or *.docx)?

                                          1 Reply Last reply
                                          0

                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved