tags:

views:

257

answers:

1

Hi! I want to read ms-excel file in java and I've also downloaded the compressed file containing 'poi' api by Apache( on the site http://jakarta.apache.org/poi) but where actually to unzip it? means in which path?? whether in org.Apache or somewhere else??

+1  A: 

I just unpacked it in the same directory as my NetBeans project and created a library as shown here.

Addendum: Download the preferred file from Apache Poi and unzip it in a convenient place such as your project directory. I added poi-3.6-20091214.jar as a new library from my NetBeans project directory.

$ ls -1
build
build.xml
manifest.mf
nbproject
poi-3.6
src
test
test.xls

Building form the command line is straightforward, too.

$ javac \
  -cp poi-3.6/poi-3.6-20091214.jar \
  -d build/classes \
  -sourcepath src \
  src/POIExcelReader.java
trashgod
Thank you very much but I want the specific description about where to download the 'poi' package!! :)
Supereme
IUUC, you already have the POI archive file and you've unzipped it. Now just put `poi-3.6-20091214.jar` on the classpath, as suggested above.
trashgod
Thank you sir!:) I tried to do so but couldn't work! :( Actually, I unzipped it one of my folders(D:\My Documents\Supria\Softwares) and then I tried to set the classpath using 'control panel' on the windows xp as 'D:\My Documents\Supria\Softwares\poi-3.6\poi-3.6-20091214.jar', but then too its not working. What can be the reason? I'm getting error as "package 'org.apache.poi.usermodel' doesn't exist", Can you please suggest?
Supereme
Supereme