I understand that but the import statement can and will only work if the environment 'knows' where to look for the classes. That direction is usually supplied by the classpath setting - it lists one or more directories/folders/archives that will be searched for the classes you are trying to import. You need to find out how to configure your environment so that you can set the classpath and have either or both NetRexx and jEdit recognise this setting. Without that, you will not be able to complete any work with POI or any other external library. As I pointed out, I know nothing about NetRexx and you will need to ask someone who does how to deal with that application. JEdit on the other hand can be configured so that it works as an IDE that you can use to develop applications that use Java code. Finally, you could use a very simple text editor to reate the source files (those that have an extension .java) and compile everything on the command line using commands such as these;
javac -classpath .;..;C:\Progarm Files\POI\poi-3.6-beta1-20091007.jar POIExample.java Here, the classpath setting points to the archive explicitly. Are you certain that you have set your classpath - http://java.sun.com/j2se/1.3/docs/tooldocs/win32/classpath.html - correctly? Yours Mark B PS The poi archive in the example above will obviously not work for you; it will need to be changed to reflect the location and true name of the POI archive on your machine. Quique Britto wrote: > > thks, the question I really need answered is what clases are needed to be > imported to read and write XLS files using POI in Java. > > I believe the problem I have lies with this is it.: > > import org.apache.poi.hssf.usermodel.HSSFWorkbook > > > > On 23 March 2010 14:37, MSB <[email protected]> wrote: > >> >> OK, that is interesting because I thought that NetRexx was designed for >> IBM's >> own 'flavour' of the Rexx programming language. Further, jEdit itself is >> a >> fully featured editor that you could use to write your Java source code >> without the need for NetRexx; that is unless you are developing using the >> Rexx language or you are 'locked in' to using this configuration by for >> example, company policy. >> >> If it were me, I would consider bypassing NetRexx and using jEdit >> directly >> to develop using Java. It would be best to install the ProjectViewer >> plugin >> into jEdit - visit http://plugins.jedit.org/plugins/?ProjectViewer to see >> a >> description of what the plugin does - as this makes it possible to use >> projects to manage your source files, the classpaths and even to create >> distributables directly. As far as I am aware, jEdit has a plugin manager >> that you could use to complete the installation of ProjectViewer, this >> page >> includes basic information http://plugins.jedit.org/. >> >> Having said that, if you have to use Netrexx, then that is outside of my >> experience and all I can suggest is that you visit IBMs NetRexx library >> at >> http://www-01.ibm.com/software/awdtools/netrexx/library/netrexxo.html and >> http://www-01.ibm.com/software/awdtools/netrexx/library.html as there may >> be >> something there to help explain what to do. I cannot imagine that it is >> impossible to reference an external library but simply do not know >> anything >> about NetRexx and so am unable to suggest how to proceed. Just as an >> aside, >> I suspect that you have been able to use the swing classes before as they >> are part of the core java api rather than being an external library. >> >> Yours >> >> Mark B >> >> >> Quique Britto wrote: >> > >> > 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] >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://old.nabble.com/Instalation-Query---Newbie-tp27988855p28000836.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-tp27988855p28003683.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]
