Firstly, make sure that you have access to the POI
javadoc web page instructions.
Excel files have the concept of a Workbook,
which is the full File, and sheets within it,
which represent sheets.
To open a file, you need to convert
a java.io.File or similar to construct the object you need.
Look at HSSFWorkbook
and HSSFSheet classes.
Also look at the "Row" classes.
You read rows, and cell indices across rows.
To copy,cut or pase, you use a "CellRangeAddress"
object.
If you're a confident java programmer, this is the start you will need!
Z.
----- Original Message -----
From: "abhishek reddy" <[email protected]>
To: <[email protected]>
Sent: Wednesday, September 30, 2009 3:45 PM
Subject: retrieving data from excel sheet using apache poi
hi every one,
Iam new to apache POI, i have excel spreadsheet with data..........
spread sheet contains information about several company
details.............
how to retrieve data specific to particular company using apache poi?
Also is there any way to retrieve distinct companies from excel sheet?
--
Abhishek
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]