I use Netrexx and compile to Java but compiler (in jEdit) returns this error. I have written simple apps in Netrexx (with gui using swing) without problems but never used external clases.
the import in Netrexx is the same as Java and I would like to modifiy some XLS files from within this program.. Hope all is clear. On 23 March 2010 13:37, MSB <[email protected]> wrote: > > 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] > >
