How to read xls.-files in qt?
-
I've tried to get some numbers or text from excel file to widget on my qt application. I mean that when I click QPushButton, listWidget shows text which is in A1 box in the excel file.
Could someone explain how to do this because I don't understand everything in doc.
Tnx! -
What are you using to read the Excel file? Is it a native .xls file with a library, or a .csv with a QFile, or what?
-
I think .xls file with a library.
-
I'm afraid that you haven't given a whole lot of information to work with. Which doc are you having trouble understanding?
-
I mean I'm so newbie with Qt that I don't know how to read docs and I'm not really good at English. Where I can learn "how to read them"?
I tryied to use activeX object, but I don't really understand how.Sorry, that I'm so stupid and beginner.
-
It's ok. We've all been beginners. It's just a matter of figuring out what you need help with.
Reading .xls files isn't a native Qt thing. As you mentioned it's more than likely done with an activeX control or a 3rd party library.
Unfortunately, I haven't dealt with that before, so I don't have a good answer for you. Hopefully someone will have some experience with that and will be able to help you out more.
-
Apart from the options mentioned by mlong, you can also considder using ODBC. You can connect to an XML file as if it is a database. It really depends what your target is what the best way to aproach this is.
-
As already discussed in "this older thread":http://developer.qt.nokia.com/forums/viewthread/2144, there is no really good, out-of-the-box solution for this. You'll have to find your own workaround for that issue, sorry.