blocks|key|126555|text|如果您使用的是Apache+POI+4.x，则可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126556|+Cell+c+=+row.getCell(3);
+if+(c+==+null+%7C%7C+c.getCellType()+==+CellType.Blank)+{
++++//+This+cell+is+empty
+}|code-block|syntax|javascript|126557|对于早于迁移到CellType枚举之前的Apache+POI3.x版本，它是：|offset|length|style|CODE|126558|+Cell+c+=+row.getCell(3);
+if+(c+==+null+%7C%7C+c.getCellType()+==+Cell.CELL_TYPE_BLANK)+{
++++//+This+cell+is+empty
+}|126559|但是，不要忘记检查Row是否为null+--如果从未使用过没有使用过单元格或样式的行，则该行本身可能为null！|126560|entityMap^0|0|0|7|8|0|0|9|3|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

If you're using Apache POI 4.x, you can do that with:
<pre><code> Cell c = row.getCell(3);
 if (c == null || c.getCellType() == CellType.Blank) {
 // This cell is empty
 }
</code></pre>
For older Apache POI 3.x versions, which predate the move to the <code>CellType</code> enum, it's:
<pre><code> Cell c = row.getCell(3);
 if (c == null || c.getCellType() == Cell.CELL_TYPE_BLANK) {
 // This cell is empty
 }
</code></pre>
Don't forget to check if the <code>Row</code> is null though - if the row has never been used with no cells ever used or styled, the row itself might be null!

blocks|key|344317|text|从Apache+POI+3.17开始，您必须使用枚举检查单元格是否为空：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|344318|import+org.apache.poi.ss.usermodel.CellType;

if(cell+==+null+%7C%7C+cell.getCellTypeEnum()+==+CellType.BLANK)+{+...+}|code-block|syntax|javascript|344319|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

As of Apache POI 3.17 you will have to check if the cell is empty using enumerations:

<pre><code>import org.apache.poi.ss.usermodel.CellType;

if(cell == null || cell.getCellTypeEnum() == CellType.BLANK) { ... }
</code></pre>

blocks|key|126613|text|Cell+cell+=+row.getCell(x,+Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|126614|这个技巧帮了我很多，看看对你有没有用|unstyled|126615|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>Cell cell = row.getCell(x, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
</code></pre>
This trick helped me a lot, see if it's useful for you

blocks|key|344397|text|从POI+3.1.7到POI+4，这是我看到的最安全、最简洁的方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|344398|boolean+isBlankCell+=+CellType.BLANK+==+cell.getCellTypeEnum();
boolean+isEmptyStringCell+=+CellType.STRING+==+cell.getCellTypeEnum()+&&+cell.getStringCellValue().trim().isEmpty();+

if+(isBlankCell+%7C%7C+isEmptyStringCell)+{
++++...|code-block|syntax|javascript|344399|从POI4开始，如果支持getCellType()，则getCellTypeEnum()将被弃用，但返回类型应保持不变。|offset|length|style|CODE|344400|entityMap^0|0|0|C|D|R|H|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

This is the safest and most concise way I see as of POI 3.1.7 up to POI 4:

<pre><code>boolean isBlankCell = CellType.BLANK == cell.getCellTypeEnum();
boolean isEmptyStringCell = CellType.STRING == cell.getCellTypeEnum() &amp;&amp; cell.getStringCellValue().trim().isEmpty(); 

if (isBlankCell || isEmptyStringCell) {
 ...
</code></pre>

As of POI 4 <code>getCellTypeEnum()</code> will be deprecated if favor of <code>getCellType()</code> but the return type should stay the same.

blocks|key|126673|text|首先，为了避免NullPointerException，您必须添加以下内容|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126674|Row.MissingCellPolicy.CREATE_NULL_AS_BLANK|code-block|syntax|javascript|126675|这将创建一个空白单元格，而不是给你NPE，然后你可以检查以确保没有出错，就像@Gagravarr所说的那样。|126676|Cell+cell+=+row.getCell(j,+Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
++++if+(cell+==+null+%7C%7C+cell.getCellTypeEnum()+==+CellType.BLANK)+
++++++++//+do+what+you+want|126677|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

First to avoid NullPointerException you have to add this

<pre><code>Row.MissingCellPolicy.CREATE_NULL_AS_BLANK
</code></pre>

This will create a blank cell instead of giving you NPE then you can check to make sure nothing went wrong just like what @Gagravarr have said.

<pre><code>Cell cell = row.getCell(j, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
 if (cell == null || cell.getCellTypeEnum() == CellType.BLANK) 
 // do what you want
</code></pre>

blocks|key|126580|text|还有另一个选择。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126581|row=(Row)+sheet.getRow(i);
++++++++if+(row+==+null+%7C%7C+isEmptyRow(row))+{
++++++++++++return;
++++++++}
Iterator<Cell>+cells+=+row.cellIterator();
++++while+(cells.hasNext())
+++++{}|code-block|syntax|javascript|126582|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

There is one other option also .

<pre><code>row=(Row) sheet.getRow(i);
 if (row == null || isEmptyRow(row)) {
 return;
 }
Iterator&lt;Cell&gt; cells = row.cellIterator();
 while (cells.hasNext())
 {}
</code></pre>

blocks|key|126584|text|.getCellType()+!=+Cell.CELL_TYPE_BLANK|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|126585|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>.getCellType() != Cell.CELL_TYPE_BLANK
</code></pre>

blocks|key|344364|text|在最新的POI+API中，Cell.getCellType()已弃用。如果您使用的是POI+API版本3.17，请使用以下代码：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|344365|if+(Cell.getCellTypeEnum()+==+CellType.BLANK)+{
++++//do+your+stuff+here
}|code-block|syntax|javascript|344366|entityMap^0|D|I|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<code>Cell.getCellType()</code> is deprecated in the latest POI API. If you are using POI API version 3.17, use the below code:

<pre><code>if (Cell.getCellTypeEnum() == CellType.BLANK) {
 //do your stuff here
}
</code></pre>

blocks|key|126733|text|试试下面的代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|126734|String+empty+=+"-";
if+(row.getCell(3)+==+null+%7C%7C+row.getCell(3).getCellType()+==+Cell.CELL_TYPE_BLANK)+{
++++upld.setValue(empty);
}+else+{
++++upld.setValue(row.getCell(3).getStringCellValue());
}|code-block|syntax|javascript|126735|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try below code:
<pre><code>String empty = &quot;-&quot;;
if (row.getCell(3) == null || row.getCell(3).getCellType() == Cell.CELL_TYPE_BLANK) {
 upld.setValue(empty);
} else {
 upld.setValue(row.getCell(3).getStringCellValue());
}
</code></pre>

I am taking input from an excel sheet using Poi.jar and wanted to know how to check if a cell is empty or not.

Right now I m using the below code.

<pre><code>cell = myRow.getCell(3);
if (cell != null) {
 cell.setCellType(Cell.CELL_TYPE_STRING);

 //System.out.print(cell.getStringCellValue() + "\t\t");
 if (cell.getStringCellValue() != "")
 depend[p] = Integer.parseInt(cell.getStringCellValue());

 }
}
</code></pre>

How to check if an excel cell is empty using Apache POI?

我正在使用Poi.jar从excel工作表中获取输入，想知道如何检查单元格是否为空。现在我正在使用下面的代码。cell = myRow.getCell(3);if (cell != null) {    cell.setCellType(Cell.CELL_TYPE_STRING);    //System.out.print(cell.getStringCellValue() + "\t\t")

问如何使用Apache POI检查excel单元格是否为空？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Apache POI检查excel单元格是否为空？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Apache POI检查excel单元格是否为空？
EN