Yes, that should be the only library you need to reference on your classpath to work with the xls files - just as an aside, I guessed at the actual name of the library based upon the zip file you downloaded. It maybe that the library you have has a slightly different name. As you write the code to process the Excel file, you will naturally need to import the specific classes from the library into your class. If you get any class not found exceptions when you try to compile or run your code, simply post again to the list and we should be able to help you work out where the problem lies; though I hope you will not see such a problem now.
Yours Mark B PS You will see some people talking about the SS classes. They are used if you have to work with both file types - the binary and xml based Excel files. It might be worth considering looking into using these classes if you think your application could be used to process both the older binary and newer xml based files; many commercial users of the POI library are doing just this sort of thing now. Quique Britto wrote: > > thks, I wish to work with XLS (office 2003) format so I believe the > classpath only will needs the poi-3.6-20091214.jar. > I will try this and come back. > > thks to all. > > > On 22 March 2010 19:00, MSB <[email protected]> wrote: > >> >> I am not too sure exactly what you are asking here as the word import is >> used >> to make a class avaailable to the code you are writing so I am going to >> assume that you are asking which archives should be added to the >> classpath. >> The answer depends on which file format are you working with, the older >> binary format (.xls) or the newer xml based one (.xlsx)? The file format >> affects - to some extent - the archives you will need to reference on >> your >> claspath in order to compile and execute the code. >> >> If you are working with the older binary file format, you should need to >> add >> just one archive onto your classpath, it will have a name something like >> this - poi-3.6-20091214.jar. >> >> On the other hand, if you are working with the newer file format - the >> xml >> based one - then you will need to add other files onto your classpath to >> support this. Looking at my IDE, I have to reference the following >> archives; >> >> poi-3.6-beta1-20091007.jar >> poi-oxml-3.6-beta1-20091007.jar >> openxml4j-1.0-beta.jar >> xmlbeans-2.3.0.jar >> ooxml-schemas-1.0.jar >> dom4j-1.6.1.jar >> >> You will need to look through the contents of the unzipped archives >> folders >> to locate the files you have downloaded with names most closely matching >> the >> examples I have given and add those onto your classpath. >> >> Yours >> >> Mark B >> >> >> Quique Britto wrote: >> > >> > Sorry if this should be common sense but I have extracted the poi zip ( >> > poi-bin-3.6-20091214.zip< >> http://www.apache.org/dyn/closer.cgi/poi/release/bin/poi-bin-3.6-20091214.zip >> >) >> > to my c:\poi-3.6\ directory. >> > I want to be able to read and write XLS files from within my >> program(s), >> > what do I need to import in my app.: >> > >> > import poi? >> > >> > any help will be highly appreciated. >> > ebm1991 >> > >> > >> >> -- >> View this message in context: >> http://old.nabble.com/Instalation-Query---Newbie-tp27988855p27990229.html >> Sent from the POI - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > -- View this message in context: http://old.nabble.com/Instalation-Query---Newbie-tp27988855p27997173.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
