POI 1

[keenanbr]

I want to use java to update excel spreadsheets. It was suggested to me to download the POI API from jakarta. I've downloaded this but what do i do with the download in order to use it.

 

[idarke]

This is the POI example page. It will show you how to do all the basic excel actions.

http://jakarta.apache.org/poi/hssf/how-to.html

 

[keenanbr]

yes, but what do i do with the download. I've unzipped it. Is there some install procedure or something that i need to do in order to use it. I can understand the documentation but i don't see anything on installing it ao what the ?*&%^$£ do i do with it

 

[JVZ]

All you have to do is put .jar file in your classpath, for example:

I'm using POI 1.5.1:

C:\TestAPI ------>POI ------->build ------>jakarta-poi-1.5.1-final-20020615.jar

So to use this API I would do the following:

Java -classpath C:\TestAPI\POI\build\jakarta-poi-1.5.1-final-20020615.jar MyProgram

If you downloaded the source version use ANT to build. I you just download the binary version.

Hope this helps.

 

[vikaschougale]

You can use a package called jxelapi which is used written for excel-java bridge. you can download it from

http://www.andykhan.com

It is simple to use just refer it's doc file which has simple examples in it.
I have used it in my Projects in current company, If u require any help contact me at vikas.chougale@learningmate.com