StreamingCell (Streaming Excel reader 2.3.5 API)

java.lang.Object
- com.github.greycode.xlsx.impl.StreamingCell

所有已实现的接口:: org.apache.poi.ss.usermodel.Cell

public class StreamingCell
extends Object
implements org.apache.poi.ss.usermodel.Cell

构造器概要

构造器
构造器和说明

StreamingCell(org.apache.poi.ss.usermodel.Sheet sheet, int columnIndex, int rowIndex, boolean use1904Dates)

构造器
构造器和说明
`StreamingCell(org.apache.poi.ss.usermodel.Sheet sheet, int columnIndex, int rowIndex, boolean use1904Dates)`

方法概要

所有方法实例方法具体方法已过时的方法
限定符和类型	方法和说明
`org.apache.poi.ss.util.CellAddress`	`getAddress()` Not supported
`org.apache.poi.ss.util.CellRangeAddress`	`getArrayFormulaRange()` Not supported
`boolean`	`getBooleanCellValue()` Get the value of the cell as a boolean.
`org.apache.poi.ss.usermodel.CellType`	`getCachedFormulaResultType()` Only valid for formula cells
`org.apache.poi.ss.usermodel.CellType`	`getCachedFormulaResultTypeEnum()` 已过时。
`org.apache.poi.ss.usermodel.Comment`	`getCellComment()` Not supported
`String`	`getCellFormula()` Return a formula for the cell, for example, `SUM(C4:E4)`
`org.apache.poi.ss.usermodel.CellStyle`	`getCellStyle()`
`org.apache.poi.ss.usermodel.CellType`	`getCellType()` Return the cell type.
`org.apache.poi.ss.usermodel.CellType`	`getCellTypeEnum()` 已过时。
`int`	`getColumnIndex()` Returns column index of this cell
`Date`	`getDateCellValue()` Get the value of the cell as a date.
`byte`	`getErrorCellValue()` Not supported
`org.apache.poi.ss.usermodel.Hyperlink`	`getHyperlink()` Not supported
`LocalDateTime`	`getLocalDateTimeCellValue()`
`double`	`getNumericCellValue()` Get the value of the cell as a number.
`String`	`getNumericFormat()`
`Short`	`getNumericFormatIndex()`
`org.apache.poi.xssf.usermodel.XSSFRichTextString`	`getRichStringCellValue()` Get the value of the cell as a XSSFRichTextString For numeric cells we throw an exception.
`org.apache.poi.ss.usermodel.Row`	`getRow()` Not Supported
`int`	`getRowIndex()` Returns row index of a row in the sheet that contains this cell
`org.apache.poi.ss.usermodel.Sheet`	`getSheet()`
`String`	`getStringCellValue()` Get the value of the cell as a string.
`String`	`getType()`
`boolean`	`isFormulaType()`
`boolean`	`isPartOfArrayFormulaGroup()` Not supported
`void`	`removeCellComment()` Not supported
`void`	`removeFormula()` Not supported
`void`	`removeHyperlink()` Not supported
`void`	`setAsActiveCell()` Not supported
`void`	`setBlank()` Not supported
`void`	`setCellComment(org.apache.poi.ss.usermodel.Comment comment)` Not supported
`void`	`setCellErrorValue(byte value)` Not supported
`void`	`setCellFormula(String formula)` Not supported
`void`	`setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle)`
`void`	`setCellType(org.apache.poi.ss.usermodel.CellType cellType)` Not supported
`void`	`setCellValue(boolean value)` Not supported
`void`	`setCellValue(Calendar value)` Not supported
`void`	`setCellValue(Date value)` Not supported
`void`	`setCellValue(double value)` Not supported
`void`	`setCellValue(LocalDate value)`
`void`	`setCellValue(LocalDateTime value)`
`void`	`setCellValue(org.apache.poi.ss.usermodel.RichTextString value)` Not supported
`void`	`setCellValue(String value)` Not supported
`void`	`setContentSupplier(com.github.greycode.xlsx.impl.Supplier contentsSupplier)`
`void`	`setFormula(String formula)`
`void`	`setFormulaType(boolean formulaType)`
`void`	`setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)` Not supported
`void`	`setNumericFormat(String numericFormat)`
`void`	`setNumericFormatIndex(Short numericFormatIndex)`
`void`	`setRawContents(Object rawContents)`
`void`	`setType(String type)`

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 构造器详细资料
  - StreamingCell
```
public StreamingCell(org.apache.poi.ss.usermodel.Sheet sheet,
                     int columnIndex,
                     int rowIndex,
                     boolean use1904Dates)
```
- 方法详细资料
  - setContentSupplier
```
public void setContentSupplier(com.github.greycode.xlsx.impl.Supplier contentsSupplier)
```
  - setRawContents
```
public void setRawContents(Object rawContents)
```
  - getNumericFormat
```
public String getNumericFormat()
```
  - setNumericFormat
```
public void setNumericFormat(String numericFormat)
```
  - getNumericFormatIndex
```
public Short getNumericFormatIndex()
```
  - setNumericFormatIndex
```
public void setNumericFormatIndex(Short numericFormatIndex)
```
  - setFormula
```
public void setFormula(String formula)
```
  - getType
```
public String getType()
```
  - setType
```
public void setType(String type)
```
  - isFormulaType
```
public boolean isFormulaType()
```
  - setFormulaType
```
public void setFormulaType(boolean formulaType)
```
  - setCellStyle
```
public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle)
```
    指定者:
    
    setCellStyle 在接口中 org.apache.poi.ss.usermodel.Cell
  - getColumnIndex
```
public int getColumnIndex()
```
    Returns column index of this cell
    
    指定者:
    
    getColumnIndex 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    zero-based column index of a column in a sheet.
  - getRowIndex
```
public int getRowIndex()
```
    Returns row index of a row in the sheet that contains this cell
    
    指定者:
    
    getRowIndex 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    zero-based row index of a row in the sheet that contains this cell
  - getRow
```
public org.apache.poi.ss.usermodel.Row getRow()
```
    Not Supported
    
    指定者:
    
    getRow 在接口中 org.apache.poi.ss.usermodel.Cell
  - getSheet
```
public org.apache.poi.ss.usermodel.Sheet getSheet()
```
    指定者:
    
    getSheet 在接口中 org.apache.poi.ss.usermodel.Cell
  - getCellType
```
public org.apache.poi.ss.usermodel.CellType getCellType()
```
    Return the cell type.
    
    指定者:
    
    getCellType 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the cell type
  - getCellTypeEnum
```
@Deprecated
public org.apache.poi.ss.usermodel.CellType getCellTypeEnum()
```
    已过时。
    
    Return the cell type.
    
    指定者:
    
    getCellTypeEnum 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the cell type Will be renamed to getCellType() when we make the CellType enum transition in POI 4.0. See bug 59791.
  - getStringCellValue
```
public String getStringCellValue()
```
    Get the value of the cell as a string. For blank cells we return an empty string.
    
    指定者:
    
    getStringCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the value of the cell as a string
  - getNumericCellValue
```
public double getNumericCellValue()
```
    Get the value of the cell as a number. For strings we throw an exception. For blank cells we return a 0.
    
    指定者:
    
    getNumericCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the value of the cell as a number
    
    抛出:
    
    NumberFormatException - if the cell value isn't a parsable double.
  - getDateCellValue
```
public Date getDateCellValue()
```
    Get the value of the cell as a date. For strings we throw an exception. For blank cells we return a null.
    
    指定者:
    
    getDateCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the value of the cell as a date
    
    抛出:
    
    IllegalStateException - if the cell type returned by getCellType() is CELL_TYPE_STRING
    
    NumberFormatException - if the cell value isn't a parsable double.
  - getBooleanCellValue
```
public boolean getBooleanCellValue()
```
    Get the value of the cell as a boolean. For strings we throw an exception. For blank cells we return a false.
    
    指定者:
    
    getBooleanCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the value of the cell as a date
  - getCellStyle
```
public org.apache.poi.ss.usermodel.CellStyle getCellStyle()
```
    指定者:
    
    getCellStyle 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the style of the cell
  - getCellFormula
```
public String getCellFormula()
```
    Return a formula for the cell, for example, SUM(C4:E4)
    
    指定者:
    
    getCellFormula 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    a formula for the cell
    
    抛出:
    
    IllegalStateException - if the cell type returned by getCellType() is not CELL_TYPE_FORMULA
  - getRichStringCellValue
```
public org.apache.poi.xssf.usermodel.XSSFRichTextString getRichStringCellValue()
```
    Get the value of the cell as a XSSFRichTextString
    For numeric cells we throw an exception. For blank cells we return an empty string. For formula cells we return the pre-calculated value if a string, otherwise an exception
    
    指定者:
    
    getRichStringCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    the value of the cell as a XSSFRichTextString
  - getCachedFormulaResultType
```
public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultType()
```
    Only valid for formula cells
    
    指定者:
    
    getCachedFormulaResultType 在接口中 org.apache.poi.ss.usermodel.Cell
    
    返回:
    
    one of (CellType.NUMERIC, CellType.STRING, CellType.BOOLEAN, CellType.ERROR) depending on the cached value of the formula
  - setCellValue
```
public void setCellValue(LocalDateTime value)
```
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - getLocalDateTimeCellValue
```
public LocalDateTime getLocalDateTimeCellValue()
```
    指定者:
    
    getLocalDateTimeCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(LocalDate value)
```
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - getCachedFormulaResultTypeEnum
```
@Deprecated
public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultTypeEnum()
```
    已过时。
    
    指定者:
    
    getCachedFormulaResultTypeEnum 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellType
```
public void setCellType(org.apache.poi.ss.usermodel.CellType cellType)
```
    Not supported
    
    指定者:
    
    setCellType 在接口中 org.apache.poi.ss.usermodel.Cell
  - setBlank
```
public void setBlank()
```
    Not supported
    
    指定者:
    
    setBlank 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(double value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(Date value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(Calendar value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(org.apache.poi.ss.usermodel.RichTextString value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellValue
```
public void setCellValue(String value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellFormula
```
public void setCellFormula(String formula)
                    throws org.apache.poi.ss.formula.FormulaParseException
```
    Not supported
    
    指定者:
    
    setCellFormula 在接口中 org.apache.poi.ss.usermodel.Cell
    
    抛出:
    
    org.apache.poi.ss.formula.FormulaParseException
  - removeFormula
```
public void removeFormula()
                   throws IllegalStateException
```
    Not supported
    
    指定者:
    
    removeFormula 在接口中 org.apache.poi.ss.usermodel.Cell
    
    抛出:
    
    IllegalStateException
  - setCellValue
```
public void setCellValue(boolean value)
```
    Not supported
    
    指定者:
    
    setCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellErrorValue
```
public void setCellErrorValue(byte value)
```
    Not supported
    
    指定者:
    
    setCellErrorValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - getErrorCellValue
```
public byte getErrorCellValue()
```
    Not supported
    
    指定者:
    
    getErrorCellValue 在接口中 org.apache.poi.ss.usermodel.Cell
  - setAsActiveCell
```
public void setAsActiveCell()
```
    Not supported
    
    指定者:
    
    setAsActiveCell 在接口中 org.apache.poi.ss.usermodel.Cell
  - getAddress
```
public org.apache.poi.ss.util.CellAddress getAddress()
```
    Not supported
    
    指定者:
    
    getAddress 在接口中 org.apache.poi.ss.usermodel.Cell
  - setCellComment
```
public void setCellComment(org.apache.poi.ss.usermodel.Comment comment)
```
    Not supported
    
    指定者:
    
    setCellComment 在接口中 org.apache.poi.ss.usermodel.Cell
  - getCellComment
```
public org.apache.poi.ss.usermodel.Comment getCellComment()
```
    Not supported
    
    指定者:
    
    getCellComment 在接口中 org.apache.poi.ss.usermodel.Cell
  - removeCellComment
```
public void removeCellComment()
```
    Not supported
    
    指定者:
    
    removeCellComment 在接口中 org.apache.poi.ss.usermodel.Cell
  - getHyperlink
```
public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()
```
    Not supported
    
    指定者:
    
    getHyperlink 在接口中 org.apache.poi.ss.usermodel.Cell
  - setHyperlink
```
public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)
```
    Not supported
    
    指定者:
    
    setHyperlink 在接口中 org.apache.poi.ss.usermodel.Cell
  - removeHyperlink
```
public void removeHyperlink()
```
    Not supported
    
    指定者:
    
    removeHyperlink 在接口中 org.apache.poi.ss.usermodel.Cell
  - getArrayFormulaRange
```
public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()
```
    Not supported
    
    指定者:
    
    getArrayFormulaRange 在接口中 org.apache.poi.ss.usermodel.Cell
  - isPartOfArrayFormulaGroup
```
public boolean isPartOfArrayFormulaGroup()
```
    Not supported
    
    指定者:
    
    isPartOfArrayFormulaGroup 在接口中 org.apache.poi.ss.usermodel.Cell

类 StreamingCell

构造器概要

方法概要

从类继承的方法 java.lang.Object

构造器详细资料

StreamingCell

方法详细资料

setContentSupplier

setRawContents

getNumericFormat

setNumericFormat

getNumericFormatIndex

setNumericFormatIndex

setFormula

getType

setType

isFormulaType

setFormulaType

setCellStyle

getColumnIndex

getRowIndex

getRow

getSheet

getCellType

getCellTypeEnum

getStringCellValue

getNumericCellValue

getDateCellValue

getBooleanCellValue

getCellStyle

getCellFormula

getRichStringCellValue

getCachedFormulaResultType

setCellValue

getLocalDateTimeCellValue

setCellValue

getCachedFormulaResultTypeEnum

setCellType

setBlank

setCellValue

setCellValue

setCellValue

setCellValue

setCellValue

setCellFormula

removeFormula

setCellValue

setCellErrorValue

getErrorCellValue

setAsActiveCell

getAddress

setCellComment

getCellComment

removeCellComment

getHyperlink

setHyperlink

removeHyperlink

getArrayFormulaRange

isPartOfArrayFormulaGroup