Reading and Writing data from excel file using java program

For handling excel files 
Apache software foundation has created a project that handles the microsoft office packages
that is "Apache poi "
This package contains the jar files which will contains the classes that can handle the microsoft office package

for downloading this package go to


http://poi.apache.org/download.html

and download   poi-bin-3.7-20101029.zip

it is a binary package contains the jar files

and you have to select packages importantley
poi-3.6-20091214.jar , poi-contrib-3.6-20091214.jar ,poi-scratchpad-3.6-20091214.jar


and if necessary other jar files also (note: the version may be veried)


and copy them and past them any folder that you like  and place the path in the classpath variable


For example :
if i have my folder in D drive with folder name "poiexample" and you have past the path like this


d:\poiexample\poi-3.6-20091214.jar;d:\poiexample\ poi-contrib-3.6-20091214.jar; d:\poiexample\poi-scratchpad-3.6-20091214.jar


so now you are ready to execute the programs 
write programs in java to handle the excel files and execute them

some of the examples are given below you can download them



https://docs.google.com/leaf?id=0B0zRF8bx4GdJZGMzOTk3Y2EtOWZlMC00YTc0LWI1YjMtOWZhMDc0ODliM2M5&hl=en&authkey=CNHw68UG


and


https://docs.google.com/leaf?id=0B0zRF8bx4GdJNThmMzQxODUtYjY3ZS00MWZmLTk1YzktZTdlYmFlMjYyZGUw&hl=en&authkey=CLeBqPIE


and enjoy programing


urs...........pavan