I don't believe so, since POI doesn't support mdb files.
I imagine you'd be looking for a separate java library for that.
----- Original Message -----
From: "abhishek reddy" <[email protected]>
To: "POI Users List" <[email protected]>
Sent: Wednesday, September 30, 2009 5:30 PM
Subject: Re: retrieving data from excel sheet using apache poi
thanks for the reply,
I can able to retrieve data normally...........iterating thru one after
the
other row and cell
Is there any way poi provides some jdbc kind of functionality in
retrieving
data?
On Wed, Sep 30, 2009 at 12:20 PM, Zachary Mitchell, BCIS <
[email protected]> wrote:
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]
--
Abhishek
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
