You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Quique Britto <eb...@gmail.com> on 2010/03/22 17:27:15 UTC

Instalation Query - Newbie

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

Re: Instalation Query - Newbie

Posted by Richard Holmes <ri...@shedconsulting.co.uk>.
Hi ebm,

Are your apps Java?  Put poi-3.6.jar into your class path and then the XLS
methods are under.

import org.apache.poi.hssf.usermodel.*;

My advice, download and use Eclipse IDE as you only type in

HSSFWorksheet

Then press CTRL-Space it shows you available classes/methods and when you
select one and press enter it auto generates the Import statements.

If you want to use the more generic SS model, which help support both XLS
and XLSX formats then import

import org.apache.poi.ss.usermodel.*;

Rich




On 22 March 2010 16:27, Quique Britto <eb...@gmail.com> 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
>

Re: Instalation Query - Newbie

Posted by Pablo Dejuan Calzolari <pa...@gmail.com>.
Dear Quique,
Here are some project examples:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/

Or you may start with, and check the documentation endorsed in your install
directory.

import org.apache.poi.ss.usermodel.Workbook;

Regards,
Pablo

On Mon, Mar 22, 2010 at 1:27 PM, Quique Britto <eb...@gmail.com> 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
>

Re: Instalation Query - Newbie

Posted by MSB <ma...@tiscali.co.uk>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
>> >> >> >> For additional commands, e-mail: user-help@poi.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> 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: user-unsubscribe@poi.apache.org
>> >> >> For additional commands, e-mail: user-help@poi.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> 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: user-unsubscribe@poi.apache.org
>> >> For additional commands, e-mail: user-help@poi.apache.org
>> >>
>> >>
>> >
>> >
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: Instalation Query - Newbie

Posted by Quique Britto <eb...@gmail.com>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> >> >> >> For additional commands, e-mail: user-help@poi.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >> 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: user-unsubscribe@poi.apache.org
> >> >> For additional commands, e-mail: user-help@poi.apache.org
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> 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: user-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: user-help@poi.apache.org
> >>
> >>
> >
> >
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: Instalation Query - Newbie

Posted by MSB <ma...@tiscali.co.uk>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
>> >> >> For additional commands, e-mail: user-help@poi.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> 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: user-unsubscribe@poi.apache.org
>> >> For additional commands, e-mail: user-help@poi.apache.org
>> >>
>> >>
>> >
>> >
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: Instalation Query - Newbie

Posted by Quique Britto <eb...@gmail.com>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> >> >> For additional commands, e-mail: user-help@poi.apache.org
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> 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: user-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: user-help@poi.apache.org
> >>
> >>
> >
> >
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: Instalation Query - Newbie

Posted by MSB <ma...@tiscali.co.uk>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
>> >> For additional commands, e-mail: user-help@poi.apache.org
>> >>
>> >>
>> >
>> >
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: Instalation Query - Newbie

Posted by Quique Britto <eb...@gmail.com>.
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 <ma...@tiscali.co.uk> 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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: user-help@poi.apache.org
> >>
> >>
> >
> >
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: Instalation Query - Newbie

Posted by MSB <ma...@tiscali.co.uk>.
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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: Instalation Query - Newbie

Posted by Quique Britto <eb...@gmail.com>.
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 <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: Instalation Query - Newbie

Posted by MSB <ma...@tiscali.co.uk>.
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org