poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zachary Mitchell, BCIS" <zac....@internode.on.net>
Subject Re: retrieving data from excel sheet using apache poi
Date Wed, 30 Sep 2009 06:50:47 GMT
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"

If you're a confident java programmer, this is the start you will need!


----- Original Message ----- 
From: "abhishek reddy" <abhishek.c1984@gmail.com>
To: <user@poi.apache.org>
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message