PDA

View Full Version : how to use api to read excel files(.xl,xls)



xiongxiongchuan
14th June 2010, 11:40
i want to read data from excel use api with fast way ,and even the computer did't install Microsoft Office,ii found an open source project called XLW,but i don't know how to use it ,

high_flyer
14th June 2010, 12:06
read this:
http://xlw.sourceforge.net/refman/

xiongxiongchuan
14th June 2010, 12:31
that is very kind of you ,but i can't find any sample code ,how to use it ,i can't thank you enough if you can give me some instruction

Naami
14th June 2010, 13:00
Hi;
File extension "xls" is a text;
Cepar between the lines with "\n" and between the column "\t".

high_flyer
14th June 2010, 13:01
in getting started they go over example code:
http://xlw.sourceforge.net/refman/gettingstarted.html

xiongxiongchuan
14th June 2010, 16:49
i have read the article "Getting Started ",but i still can't understanding what 's the article talking about,

high_flyer
14th June 2010, 16:57
"can't understand" is a very broad term.
If you show us what you have tried, what you have expected from that code, and what problem you encountered we might help you.
Though, this has nothing to do with Qt, and totally off topic.

wysota
14th June 2010, 18:18
Just my five cents: I don't think xlw will work without Excel being installed on the machine. I think it is intended to create custom functions for Excel not to operate on xls files.

xiongxiongchuan
14th June 2010, 20:52
as wysota said that ,is there any soilution for this ?

wysota
15th June 2010, 01:38
xls is a proprietary format and no software apart Excel itself will handle it properly in all situations.