poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abhishek reddy <abhishek.c1...@gmail.com>
Subject Re: retrieving data from excel sheet using apache poi
Date Wed, 30 Sep 2009 08:00:54 GMT
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 <
zac.j.m@internode.on.net> 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" <
> 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
>
>


-- 
Abhishek

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message