Silly question maybe but when are you seeing this error? Is your IDE/editor telling you that it cannot locate the class as you are writing the code or is the compiler returning errors when you try to compile the Java code? Just as an aside, what editor/IDE are you using? It may well be the case that you have to add the library to it in some way. For example, I use NetBeans and I have to add any external libraries into the project so that they can be imported into the code as I develop it. Further, how much experience do you have writing code with Java? Sorry if this sounds impertinent but it helps me now how much detail to include in any answers.
Yours Mark B Quique Britto wrote: > > thanks again for the explanation. basically I need to simply be able to > get > and put values in an already created XLS speadsheet. > > how do i know what classes to import, I have looked through the POI web > site > but the examples I try (see below) return in errors. > > import org.apache.poi.hssf.usermodel.HSSFWorkbook > > returns with class cannot be found to import. > > > again thks for yr help. > > > > On 23 March 2010 08:40, MSB <[email protected]> wrote: > >> >> 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] >> >> > > -- View this message in context: http://old.nabble.com/Instalation-Query---Newbie-tp27988855p28000210.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]
