为什么无法把null的值置为空值?
wwkan 2004-11-29 06:25:58 导出的数据有很多是“null”值,我想把null值用空白替换,于是加入以下代码:
//把null值改为空白
if (((HashMap)map.get(((pageNum-1)*pageSize+rownum)+"")).get(fieldName).toString()==null){
cell.setCellValue("");
}
结果导出的还是null值,请问哪里有错呢?
原代码:
for (rownum = (short) 1; (((pageNum-1)*pageSize+rownum)<=totalNum )
&& rownum <= pageSize; rownum++){
absRowCount=absRowCount+1;
temp=rownum;
row = sheet.createRow(absRowCount-1); //创建新行
row.setHeight(height);
cellnum=0; //重新置0
for (Iterator i2 = element.elementIterator("td");
i2.hasNext(); )
{
Element element2 = (Element) i2.next();
fieldName=element2.attributeValue("class");
cell = row.createCell(cellnum);
cell.setCellStyle(HeaderStyle);
cell.setEncoding( (short) HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(((HashMap)map.get(((pageNum-1)*pageSize+rownum)+"")).get(fieldName).toString());
//把null值改为空白
if (((HashMap)map.get(((pageNum-1)*pageSize+rownum)+"")).get(fieldName).toString()==null){
cell.setCellValue("");
}
cellnum = (short) (cellnum + 1);
}
}