Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of abhishek.c1984@gmail.com
 designates 209.85.216.181 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=PyVBNP+EJh/NdrRZUbih8Rj6fCVZRy2rxUer9mpmT4GHdIc/BX00zCR7xj0QSL3PFD
         ZZGYPC6hA/bNHD3le8xUqVpezHGxv7kXzKgQpyvgTCqEeH9lQUnz0kANnWPqaDhBbr1m
         VpO94hLaLMN5MVyehMzPAb7e1STcIHdMhIkE0=
MIME-Version: 1.0
In-Reply-To: <44B603857DEB4734B517362855BDAE49@zachary>
References: <d9547ce70909292315j524b9df9t60d4dee0030f1c44@mail.gmail.com>
	 <44B603857DEB4734B517362855BDAE49@zachary>
Date: Wed, 30 Sep 2009 13:30:54 +0530
Message-ID: <d9547ce70909300100rcb3f413w3155a7ef38304651@mail.gmail.com>
Subject: Re: retrieving data from excel sheet using apache poi
From: abhishek reddy <abhishek.c1984@gmail.com>
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=00504502920327efdd0474c6eed3

--00504502920327efdd0474c6eed3
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502920327efdd0474c6eed3--