poi生成的excel中,如果数据库中某项值显示是空白的 ,在excel中这一格就会显示“null”,
要怎么修改才能改成和数据库中一样显示空白呢?
关键代码如下:public void WriteExcel(FileOutputStream fOut,ResultSet rs) throws SQLException, IOException{
XSSFWorkbook workbook = new XSSFWorkbook();
// FileOutputStream fOut = new FileOutputStream(".\\" + args[0]
// + "\\" + filename + ".xlsx");
XSSFSheet sheet = workbook.createSheet();
workbook.setSheetName(0, "sheet");
XSSFRow row = sheet.createRow((short) 0);
XSSFCell cell;
ResultSetMetaData md = rs.getMetaData();
int nColumn = md.getColumnCount(); for (int i = 1; i <= nColumn; i++) {
cell = row.createCell((short) (i - 1));
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellValue(new XSSFRichTextString(md
.getColumnLabel(i)));
}
int iRow = 1;
while (rs.next()) {
row = sheet.createRow((short) iRow);
;
for (int j = 1; j <= nColumn; j++) {
cell = row.createCell((short) (j - 1));
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellValue(new XSSFRichTextString(rs
.getObject(j) + ""));
}
iRow++;
} workbook.write(fOut);
fOut.flush();
fOut.close();
}
要怎么修改才能改成和数据库中一样显示空白呢?
关键代码如下:public void WriteExcel(FileOutputStream fOut,ResultSet rs) throws SQLException, IOException{
XSSFWorkbook workbook = new XSSFWorkbook();
// FileOutputStream fOut = new FileOutputStream(".\\" + args[0]
// + "\\" + filename + ".xlsx");
XSSFSheet sheet = workbook.createSheet();
workbook.setSheetName(0, "sheet");
XSSFRow row = sheet.createRow((short) 0);
XSSFCell cell;
ResultSetMetaData md = rs.getMetaData();
int nColumn = md.getColumnCount(); for (int i = 1; i <= nColumn; i++) {
cell = row.createCell((short) (i - 1));
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellValue(new XSSFRichTextString(md
.getColumnLabel(i)));
}
int iRow = 1;
while (rs.next()) {
row = sheet.createRow((short) iRow);
;
for (int j = 1; j <= nColumn; j++) {
cell = row.createCell((short) (j - 1));
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellValue(new XSSFRichTextString(rs
.getObject(j) + ""));
}
iRow++;
} workbook.write(fOut);
fOut.flush();
fOut.close();
}
解决方案 »
- 再次求助兄弟们一个正则表达式.....
- 十万火急!!如何输出SHORT数组到文件
- 小小逻辑搞不清楚啦!谢谢各位。
- 关于接口中的中实现接口方法的问题
- 与对方厂家讨论webservice接口,我觉得应该提供WSDL,同事认为提供XSD+XML即可,大家认为呢
- SWT中Label如何能既显示图片又能加入文字???
- 求助:ant教程,高手请给小弟指条路啊
- 有没有谓词演算,命题演算的算法,或具体函数库?
- merlin运行是出了问题,请问如何解决?
- 为什么再测试BMP时候,客户端报出Return value from create(123,123):null?
- 又触礁了,高人来看看!
- java多线程生产者-消费者模式问题请教
cell.setCellValue(new XSSFRichTextString(rs.getObject(j) + ""));如果你的rs.getObject(j)是null 那么 null + "" 还是等于null呀你可以这么来
Object value = rs.getObjec(j);value = value == null ? "" : value;cell.setCellValue(value);