Installing and using Apache POI

[segrigo <se...@hotmail.com>]

Hello all,

I am a new user of Apache POI and a students in a French  Ingeneer School
(master equivalent).
Because of a school project with the INRA, we have to use Java in order to
create a soft. This one must allow the creation and reading of excel sheet.

I've looking for an answer on the forum but do not perform to find it.
So I write this post in order to find how to install POI ?
I downloaded the zip file and try to use .jar files in eclipse. But eclipse
load the files, show packages but not the classes. So it's quite difficult
to discover the API and to see how it works.

Can someone help me please ?
Thanks a lot.

Quentin

-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Installing-and-using-Apache-POI-tp3373965p3373965.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: Installing and using Apache POI

[Mark Beardsley <ma...@tiscali.co.uk>]

Can I ask how much experience you have with the Java language please? If you
do not yet understand how to import packages and how to create and
manipulate objects, then it would be worthwhile reading through a simple
Java tutorial before going any further. The reason I ask is that you do not
'install' POI in the way you would Excel for instance. Instead, you copy the
archives - those files that have the .jar extension, into a folder on your
machine and then import from them the various classes you need in order for
your code to compile and run. I cannot help with anything specific to Ecipse
as I use a different IDE, sorry.

Secondly, which version of the Excel file format do you want to target? If
you are uncertain, there are two - the older binary file format with files
whose extension is .xls and the newer xml based file format with files whose
extension is .xlsx. POI is ablt os upport both; the HSSF stream supports the
binary file format whilst XSSF supports the xml based one. Furthermore,
there is the SS stream that allows you to create code that will work
irespective of the files format; you can use the same code base to
edit/create both binary and xml based files.

To get started with the api, take a look here
http://poi.apache.org/spreadsheet/quick-guide.html. That page contains lots
of code snippets that show how to complete a number of basic operations.
They do not show any of the supporting code that will need to be written nor
how to create a complete application. To look at that sort of information,
take a look here http://poi.apache.org/spreadsheet/examples.html. They are
complete examples showing how to create specifc workbooks. Finally, when you
have a specific question about the api which is not answered elsewhere, just
post a question onto the list.

Yours

Mark B
-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Installing-and-using-Apache-POI-tp3373965p3374316.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