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] > >
