Assuming you mean percentage, I have not done this myself, but it would seem
that you would simply setup a Cell Style with a data format consistent with
percentage.
Maybe something like this:
double myValue = 0.7;
.
.
.
HSSFCellStyle cellStyle = myWorkbook.createCellStyle();
HSSFCell cell = row.getCell((short)1);
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0%"));
- or -
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00%"));
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
cell.setValue(myValue);
I hope this helps send you in the right direction.
- MJD
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 8:21 AM
To: POI Users List
Subject: setting cell to pourcentage type
Hi,
I would like to know what cell type I must set for contain pourcentage
value ?
thanks
Stéphane Purnelle
-----------------------------------
Stéphane PURNELLE [EMAIL PROTECTED]
Service Informatique Corman S.A. Tel : 00 32 087/342467
****************************************************************************
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
****************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
