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 dave2wave@comcast.net
 designates 76.96.30.17 as permitted sender)
Subject: Re: [Excel- Blank/Empty Cell]
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Dave Fisher <dave2wave@comcast.net>
In-Reply-To: <BANLkTi=WLr=BFTmvP2s576pX8=Ukvg3X8w@mail.gmail.com>
Date: Wed, 1 Jun 2011 08:00:54 -0700
Cc: hamza.abdelkebir@gmail.com
Content-Transfer-Encoding: quoted-printable
Message-Id: <3241FF0A-CCA4-4C45-B358-A9618BE5470E@comcast.net>
References: <BANLkTi=HnsYzi-OveU5WkAVt7BiVgQF3Jw@mail.gmail.com>
 <BANLkTi=k8j8fc9-si78ZzqHkfB23HQ1rAA@mail.gmail.com>
 <BANLkTi=WLr=BFTmvP2s576pX8=Ukvg3X8w@mail.gmail.com>
To: "POI Users List" <user@poi.apache.org>

Hi -

Look for MissingCellPolicy and set it according to your needs.

Regards,
Dave

On Jun 1, 2011, at 4:48 AM, rahul.soa wrote:

> Hi Hamza,
>=20
> Thanks for your email.
>=20
> It did not really work for me.
>=20
> for (HSSFRow row =3D (HSSFRow) rows.next(); rows.hasNext(); row =3D
> (HSSFRow) rows.next()) {
>                Iterator cells =3D row.cellIterator();
>                for (HSSFCell cell =3D (HSSFCell) cells.next(); =
cells.hasNext();
>                        cell =3D (HSSFCell) cells.next()) {
> }
>=20
> I think [ cell =3D (HSSFCell) cells.next()) ] "cell" does not consider
> blank/empty cell in the sheet so
> cell.getStringCellValue().compareTo("") did not work for me.
>=20
> Now my requirement has changed, so changed my program accordingly.
>=20
> Rahul
>=20
> On Tue, May 31, 2011 at 2:24 PM, Hamza Abdelkebir
> <hamza.abdelkebir@gmail.com> wrote:
>> Hello,
>> You could maybe try testing like this
>>=20
>> cell.getStringCellValue().compareTo("");
>>=20
>> Not sure this workds though,
>>=20
>> Regards,
>> --
>> Hamza
>>=20
>>=20
>>=20
>>=20
>> On Tue, May 31, 2011 at 2:20 PM, rahul.soa <rahul.soa@googlemail.com> =
wrote:
>>=20
>>> Hello Users, Devs,
>>>=20
>>> Sorry for asking a common question as I could not find the exact
>>> answer, how to find a cell which is blank/empty (cell does not have
>>> any value). Is there a way to know this? I have several rows of data
>>> in xls file where in each row one or more cells are blank/empty. In =
my
>>> program I would like to consider those blank/empty cells.
>>>=20
>>> Many Thanks,
>>> Rahul
>>>=20
>>> =
---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>=20
>>>=20
>>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>=20


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org