Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <A5E4B3E29A55D511A2AD0006299976EC0734CF7E@KSKoeln3>
From: "Marx,
 Stefan ext. MA Fa. Lynx" <Stefan.Marxext.MAFa.Lynx@rewe-group.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Subject: AW: numeric cell type
Date: Wed, 12 Jul 2006 09:30:33 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Abhinav,

in this area I encountered similar problems. Due to other circumstances =
I
can't switch to the solution to proceed each numeric value with a ', so =
I
ended up in this work-a-round:

[..]
                     final int cellType =3D cell.getCellType();
                     if (cellType =3D=3D HSSFCell.CELL_TYPE_NUMERIC)
                     {
                        mydouble =3D new =
Double(cell.getNumericCellValue());
                     }
                     else if (cellType =3D=3D =
HSSFCell.CELL_TYPE_STRING)
                     {
                        myString =3D cell.getStringCellValue();
                        mydouble =3D parseStringVal(myString);
                     }
[..]

May be this solution is worth to consider for your problem.

Greetings from Cologne, Germany,

cu Stefan

Stefan Marx
Marx Consulting (extern)

REWE GROUP=20
Gesch=E4ftsbereich Konzern-Systeme
Funktionsbereich Business-Systeme

REWE-Informations-Systeme GmbH
Humboldtstra=DFe 140-144 - 51149 K=F6ln

Telefon:  +49 (0)221 149 - 5953
Telefax:  +49 (0)221 149 - 97 5953
E-Mail: Stefan.Marxext.MAFa.Lynx@rewe-group.com
www.rewe-group.com


> -----Urspr=FCngliche Nachricht-----
> Von:	Abhinav Srivastava [SMTP:wri2me@gmail.com]
> Gesendet am:	Mittwoch, 12. Juli 2006 02:28
> An:	poi-user@jakarta.apache.org
> Betreff:	numeric cell type
>=20
> While reading a XLS using HSSF, cells which contain numbers
> are being returned as type NUMERIC. e.g a cell having 2 would have =
its
> value returned as 2.0 (double) and not as "2" as I would like it to.
> any help?


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/