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 mathaiaju@gmail.com designates
 209.85.220.220 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:content-transfer-encoding;
        b=Tipk36ZIc1FshM2YwuGoVhnedkxATAt8P/RcaMPNfKZp6aNuZxl7iwl+XqLVnexK+F
         X6Qckz6KgBo1AKTzaTnWwamS+ebe/aopiZbHONzaiTARqM/LJ0kIMZA1rigEY1347Sju
         8oz0VL1iCNIvEVi0y91dHfJtjaUIYd38Hf6mM=
MIME-Version: 1.0
In-Reply-To: <27269628.post@talk.nabble.com>
References: <42184d2d1001210116l2769be81x76f9b770d5d82ec4@mail.gmail.com>
	 <27269628.post@talk.nabble.com>
Date: Mon, 25 Jan 2010 18:23:40 +0530
Message-ID: <42184d2d1001250453s17295eb6k7fe76de5b0eefaf1@mail.gmail.com>
Subject: Re: Problem reading XLS files
From: Aju Mathai <mathaiaju@gmail.com>
To: POI Users List <user@poi.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

 Hi Mark,
>
> The file is generated automatically without any user intervention. How
> do i find out whether the excel file has been modified in the ways you
> talk about ? . The POI version that i am using is 3.5_beta3.
>
> Thanks & Regards,
> mathaj

On Fri, Jan 22, 2010 at 1:12 PM, MSB <markbrdsly@tiscali.co.uk> wrote:
>
> Excel can behave quite oddly at times and it will create a record for a c=
ell
> if it has been 'touched' in any way by the user during creation of the fi=
le.
> By this, I mean that if the user entered a value into a cell and then
> cleared that out or if they set a format and then removied it, Excel will
> recognise that something was done to the cell and will create a record fo=
r
> it in the file. Without seeing the actual file/files you are working with=
 I
> cannot comment much further but do suspect that this may have been the ca=
se;
> either the user or the application that created the file left a few of th=
ese
> artifacts around. I do not expect that this is a problem with POI but to =
be
> certain, can you post one of the files that is exhibiting this sort of
> behaviour so that we could take a closer look at it please? Further, can =
you
> say which version of the API you are using and how the Excel file is
> generated - by someone using Excel or by another application - please?
>
> Yours
>
> Mark B
>
>
>
> Aju Mathai wrote:
>>
>> Hi,
>>
>> I am using the following POI libraries to read in the files with .xls
>> and .xlsx files. I found a strange problem ,the celliterator.hasNext()
>> sometimes gives true even if the next column in my xls file seems to
>> be blank, i have no additional columns. How do i take care of such
>> blank cells ?
>>
>> Here is my code snippet
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 for(Iterator<Cell> ri =3D row.ce=
llIterator();
>> ri.hasNext();) =A0{
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Cell cell =3D ri.next();
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 switch(cell.=
getCellType()){
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 case Cell.CE=
LL_TYPE_STRING:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append(cell.getRichStringCellValue().getString().trim());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 break;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 case Cell.CE=
LL_TYPE_NUMERIC:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append(cell.getNumericCellValue());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 break;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 case Cell.CE=
LL_TYPE_BOOLEAN:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append(cell.getBooleanCellValue());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 break;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 case Cell.CE=
LL_TYPE_FORMULA:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append(cell.getCellFormula());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 break;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 case Cell.CE=
LL_TYPE_BLANK:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 break;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 default:
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append("");
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 }
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 // Column De=
limiter
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 if(ri.hasNex=
t() && =A0!(cell.getCellType() =3D=3D Cell.CELL_TYPE_BLANK))
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 text.append(COLUMN_DELIMITER);
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 }
>>
>>
>> Thanks
>> mathaj
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>
> --
> View this message in context: http://old.nabble.com/Problem-reading-XLS-f=
iles-tp27254834p27269628.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

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