NullCell (hutool 5.8.41 API)

java.lang.Object
- cn.hutool.poi.excel.cell.NullCell

All Implemented Interfaces:

org.apache.poi.ss.usermodel.Cell
```
public class NullCell
extends Object
implements org.apache.poi.ss.usermodel.Cell
```
当单元格不存在时使用此对象表示，得到的值都为null,此对象只用于标注单元格所在位置信息。

Since:

5.5.0

Author:

looly

Constructor Summary

Constructors
Constructor and Description

NullCell(org.apache.poi.ss.usermodel.Row row, int columnIndex)
构造

Constructors
Constructor and Description
`NullCell(org.apache.poi.ss.usermodel.Row row, int columnIndex)` 构造

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`org.apache.poi.ss.util.CellAddress`	`getAddress()`
`org.apache.poi.ss.util.CellRangeAddress`	`getArrayFormulaRange()`
`boolean`	`getBooleanCellValue()`
`org.apache.poi.ss.usermodel.CellType`	`getCachedFormulaResultType()`
`org.apache.poi.ss.usermodel.CellType`	`getCachedFormulaResultTypeEnum()`
`org.apache.poi.ss.usermodel.Comment`	`getCellComment()`
`String`	`getCellFormula()`
`org.apache.poi.ss.usermodel.CellStyle`	`getCellStyle()`
`org.apache.poi.ss.usermodel.CellType`	`getCellType()`
`org.apache.poi.ss.usermodel.CellType`	`getCellTypeEnum()`
`int`	`getColumnIndex()`
`Date`	`getDateCellValue()`
`byte`	`getErrorCellValue()`
`org.apache.poi.ss.usermodel.Hyperlink`	`getHyperlink()`
`LocalDateTime`	`getLocalDateTimeCellValue()`
`double`	`getNumericCellValue()`
`org.apache.poi.ss.usermodel.RichTextString`	`getRichStringCellValue()`
`org.apache.poi.ss.usermodel.Row`	`getRow()`
`int`	`getRowIndex()`
`org.apache.poi.ss.usermodel.Sheet`	`getSheet()`
`String`	`getStringCellValue()`
`boolean`	`isPartOfArrayFormulaGroup()`
`void`	`removeCellComment()`
`void`	`removeFormula()`
`void`	`removeHyperlink()`
`void`	`setAsActiveCell()`
`void`	`setBlank()`
`void`	`setCellComment(org.apache.poi.ss.usermodel.Comment comment)`
`void`	`setCellErrorValue(byte value)`
`void`	`setCellFormula(String formula)`
`void`	`setCellStyle(org.apache.poi.ss.usermodel.CellStyle style)`
`void`	`setCellType(org.apache.poi.ss.usermodel.CellType cellType)`
`void`	`setCellValue(boolean value)`
`void`	`setCellValue(Calendar value)`
`void`	`setCellValue(Date value)`
`void`	`setCellValue(double value)`
`void`	`setCellValue(LocalDateTime value)`
`void`	`setCellValue(org.apache.poi.ss.usermodel.RichTextString value)`
`void`	`setCellValue(String value)`
`void`	`setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.poi.ss.usermodel.Cell
setCellValue

- Constructor Detail
  - NullCell
```
public NullCell(org.apache.poi.ss.usermodel.Row row,
                int columnIndex)
```
    构造
    
    Parameters:
    
    row - 行
    
    columnIndex - 列号，从0开始
- Method Detail
  - getColumnIndex
```
public int getColumnIndex()
```
    Specified by:
    
    getColumnIndex in interface org.apache.poi.ss.usermodel.Cell
  - getRowIndex
```
public int getRowIndex()
```
    Specified by:
    
    getRowIndex in interface org.apache.poi.ss.usermodel.Cell
  - getSheet
```
public org.apache.poi.ss.usermodel.Sheet getSheet()
```
    Specified by:
    
    getSheet in interface org.apache.poi.ss.usermodel.Cell
  - getRow
```
public org.apache.poi.ss.usermodel.Row getRow()
```
    Specified by:
    
    getRow in interface org.apache.poi.ss.usermodel.Cell
  - setCellType
```
public void setCellType(org.apache.poi.ss.usermodel.CellType cellType)
```
    Specified by:
    
    setCellType in interface org.apache.poi.ss.usermodel.Cell
  - setBlank
```
public void setBlank()
```
    Specified by:
    
    setBlank in interface org.apache.poi.ss.usermodel.Cell
  - getCellType
```
public org.apache.poi.ss.usermodel.CellType getCellType()
```
    Specified by:
    
    getCellType in interface org.apache.poi.ss.usermodel.Cell
  - getCellTypeEnum
```
public org.apache.poi.ss.usermodel.CellType getCellTypeEnum()
```
    Specified by:
    
    getCellTypeEnum in interface org.apache.poi.ss.usermodel.Cell
  - getCachedFormulaResultType
```
public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultType()
```
    Specified by:
    
    getCachedFormulaResultType in interface org.apache.poi.ss.usermodel.Cell
  - getCachedFormulaResultTypeEnum
```
public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultTypeEnum()
```
    Specified by:
    
    getCachedFormulaResultTypeEnum in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(double value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(Date value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(LocalDateTime value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(Calendar value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(org.apache.poi.ss.usermodel.RichTextString value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(String value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellFormula
```
public void setCellFormula(String formula)
                    throws org.apache.poi.ss.formula.FormulaParseException,
                           IllegalStateException
```
    Specified by:
    
    setCellFormula in interface org.apache.poi.ss.usermodel.Cell
    
    Throws:
    
    org.apache.poi.ss.formula.FormulaParseException
    
    IllegalStateException
  - removeFormula
```
public void removeFormula()
                   throws IllegalStateException
```
    Specified by:
    
    removeFormula in interface org.apache.poi.ss.usermodel.Cell
    
    Throws:
    
    IllegalStateException
  - getCellFormula
```
public String getCellFormula()
```
    Specified by:
    
    getCellFormula in interface org.apache.poi.ss.usermodel.Cell
  - getNumericCellValue
```
public double getNumericCellValue()
```
    Specified by:
    
    getNumericCellValue in interface org.apache.poi.ss.usermodel.Cell
  - getDateCellValue
```
public Date getDateCellValue()
```
    Specified by:
    
    getDateCellValue in interface org.apache.poi.ss.usermodel.Cell
  - getLocalDateTimeCellValue
```
public LocalDateTime getLocalDateTimeCellValue()
```
    Specified by:
    
    getLocalDateTimeCellValue in interface org.apache.poi.ss.usermodel.Cell
  - getRichStringCellValue
```
public org.apache.poi.ss.usermodel.RichTextString getRichStringCellValue()
```
    Specified by:
    
    getRichStringCellValue in interface org.apache.poi.ss.usermodel.Cell
  - getStringCellValue
```
public String getStringCellValue()
```
    Specified by:
    
    getStringCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(boolean value)
```
    Specified by:
    
    setCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellErrorValue
```
public void setCellErrorValue(byte value)
```
    Specified by:
    
    setCellErrorValue in interface org.apache.poi.ss.usermodel.Cell
  - getBooleanCellValue
```
public boolean getBooleanCellValue()
```
    Specified by:
    
    getBooleanCellValue in interface org.apache.poi.ss.usermodel.Cell
  - getErrorCellValue
```
public byte getErrorCellValue()
```
    Specified by:
    
    getErrorCellValue in interface org.apache.poi.ss.usermodel.Cell
  - setCellStyle
```
public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle style)
```
    Specified by:
    
    setCellStyle in interface org.apache.poi.ss.usermodel.Cell
  - getCellStyle
```
public org.apache.poi.ss.usermodel.CellStyle getCellStyle()
```
    Specified by:
    
    getCellStyle in interface org.apache.poi.ss.usermodel.Cell
  - setAsActiveCell
```
public void setAsActiveCell()
```
    Specified by:
    
    setAsActiveCell in interface org.apache.poi.ss.usermodel.Cell
  - getAddress
```
public org.apache.poi.ss.util.CellAddress getAddress()
```
    Specified by:
    
    getAddress in interface org.apache.poi.ss.usermodel.Cell
  - setCellComment
```
public void setCellComment(org.apache.poi.ss.usermodel.Comment comment)
```
    Specified by:
    
    setCellComment in interface org.apache.poi.ss.usermodel.Cell
  - getCellComment
```
public org.apache.poi.ss.usermodel.Comment getCellComment()
```
    Specified by:
    
    getCellComment in interface org.apache.poi.ss.usermodel.Cell
  - removeCellComment
```
public void removeCellComment()
```
    Specified by:
    
    removeCellComment in interface org.apache.poi.ss.usermodel.Cell
  - getHyperlink
```
public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()
```
    Specified by:
    
    getHyperlink in interface org.apache.poi.ss.usermodel.Cell
  - setHyperlink
```
public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)
```
    Specified by:
    
    setHyperlink in interface org.apache.poi.ss.usermodel.Cell
  - removeHyperlink
```
public void removeHyperlink()
```
    Specified by:
    
    removeHyperlink in interface org.apache.poi.ss.usermodel.Cell
  - getArrayFormulaRange
```
public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()
```
    Specified by:
    
    getArrayFormulaRange in interface org.apache.poi.ss.usermodel.Cell
  - isPartOfArrayFormulaGroup
```
public boolean isPartOfArrayFormulaGroup()
```
    Specified by:
    
    isPartOfArrayFormulaGroup in interface org.apache.poi.ss.usermodel.Cell

Class NullCell

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.apache.poi.ss.usermodel.Cell

Constructor Detail

NullCell

Method Detail

getColumnIndex

getRowIndex

getSheet

getRow

setCellType

setBlank

getCellType

getCellTypeEnum

getCachedFormulaResultType

getCachedFormulaResultTypeEnum

setCellValue

setCellValue

setCellValue

setCellValue

setCellValue

setCellValue

setCellFormula

removeFormula

getCellFormula

getNumericCellValue

getDateCellValue

getLocalDateTimeCellValue

getRichStringCellValue

getStringCellValue

setCellValue

setCellErrorValue

getBooleanCellValue

getErrorCellValue

setCellStyle

getCellStyle

setAsActiveCell

getAddress

setCellComment

getCellComment

removeCellComment

getHyperlink

setHyperlink

removeHyperlink

getArrayFormulaRange

isPartOfArrayFormulaGroup