Question

java poi 读取excel 获得一行的单元格个数不对

获取单元格个数，如果为空的单元格 获取不到，只能读到有值的单元格的个数，求大神

代码如上，我的excel 总共有22列，获得的cells 只是有值的单元格，空的单元格获取不到

Answer 1

package com.linyis.test1;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
public class HssfCells
{
public void getCellValues(HSSFSheet sheet)
{
if(sheet == null)
{
System.out.println("sheet is null");
return ;
}
for(int i = 0 ; i < sheet.getLastRowNum() ; i ++)
{
HSSFRow row = sheet.getRow(i) ;
if(row == null)
{
System.out.println("单元格第" + (i+1)+ "行为空");
}
else
{
for(int j = 0 ; j < row.getLastCellNum() ; j ++)
{
HSSFCell cell = row.getCell(j) ;
if(cell == null)
{
System.out.println("单元格第" + (i+1)+ "行 " + (j+1) + "列为null");
}
else
{
String s = cell.getCellType() == HSSFCell.CELL_TYPE_STRING?cell.getStringCellValue():cell.getNumericCellValue()+"";
System.out.println("单元格第" + (i+1)+ "行 " + (j+1) + "列值为" + s);
}
}
}
}
}
}