Carlos,
This should be helpful:
java.text.DecimalFormat de = new
java.text.DecimalFormat("#,##0");
String numericString =
de.format(Double.parseDouble(value)).toString();
Try this format.
Thanks,
Anuj
-Original Message-
From: Carlos Bergueira [mailto:[EM
cannot read interpret. I even try to use new Alpha
version HSSFFormularEvaluator and that allways failed
with Null exceptions.
Igor
--- "Anand,Anuj" <[EMAIL PROTECTED]> wrote:
>
> Actually PhysicalRowNumber returns less number of
> rows in the
> spreadsheet. Only 32 HS
those rows are not created by Excel since
formula did not return values so the problem is
PhysicalRowNumber returns more rows then actually in a
sheet.
You need to test your code for Row being NOT NULL and
it will work ok or check youe formulas.
Igor
--- "Anand,Anuj" <[EMAIL
riginal Message-
From: Anand,Anuj [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 3:25 PM
To: POI Users List
Subject: RE: Problem reading Excel File
Sorry for sending out the message repeatedlyAttached is the
inline
code
switch(i) {
// Internal Date Formats as described on page 427 in Microsoft
case 0x0e:
case 0x0f:
case 0x10:
case 0x11:
case 0x12:
case 0x13:
case 0x14:
case 0x15:
case 0x16:
case 0x2d:
case 0x2e:
case 0x2f:
bDa
is happening?
-Original Message-----
From: Anand,Anuj
Sent: Monday, August 29, 2005 3:35 PM
To: 'poi-user@jakarta.apache.org'
Subject: FW:
-Original Message-----
From: Anand,Anuj
Sent: Monday, August 29, 2005 3:27 PM
To: '[EMAIL PROTECTED]
Title: FW:
-Original Message-
From: Anand,Anuj
Sent: Monday, August 29, 2005 3:27 PM
To: '[EMAIL PROTECTED]'
Subject:
I need to resolve the following spreadsheet
<>
POI is reading only the first 32 rows from it. Cna somebody help
Just had a small question.
I am actually reading an excel file on the server using POI. Do I need excel
to be installed on that server?
Thanks,
ANuj
-Original Message-
From: Andrej Golovnin [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2003 7:27 AM
To: POI Users List
Subject: Re
