Hi,
I've noticed that when I run the following method that I've written all
the formats for all the unsed cells are changed to the format I pass in.
Is there a way to only affect the format of the cell?, I might be doing
this wrong?. I thought i'm only affecting the one cell.
/**
* set a cell in the work book (in right sheet) as date.
* <p/>
*
* @param sheet the sheet we want to update
* @param date is the date you want to set
* @param x is the X co-ord
* @param y is the y co-ord
* @param mask is the formatting mask used
*/
public void setValueOfCellAsDateInSheet(int sheet,
Date date,
int x,
int y,
String mask) {
HSSFCell theCell = ensureCellExists(sheet, x, y);
HSSFCellStyle dateCellStyle = theCell.getCellStyle();
HSSFDataFormat format = workbook.createDataFormat();
dateCellStyle.setDataFormat(format.getFormat(mask));
theCell.setCellValue(date);
}
Here is the method I used in the above method (in case it matters) ...
/**
* Given a sheet, x and y this method will create all the parents
bits and
* the cell to ensure it exists in the workbook
*/
protected HSSFCell ensureCellExists(int sheet,
int x,
int y) {
HSSFSheet theSheet = workbook.getSheetAt(sheet);
HSSFRow theRow = theSheet.getRow(y);
if (null == theRow) {
theRow = theSheet.createRow(y);
}
HSSFCell theCell = theRow.getCell((short) x);
if (null == theCell) {
theCell = theRow.createCell((short) x);
}
return theCell;
}
---------------------------------------------------------------------
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/
