org.dromara.hutool.poi.excel.cell

Class VirtualCell

java.lang.Object

org.apache.poi.ss.usermodel.CellBase

org.dromara.hutool.poi.excel.cell.VirtualCell

All Implemented Interfaces:

org.apache.poi.ss.usermodel.Cell

public class VirtualCell
extends org.apache.poi.ss.usermodel.CellBase

虚拟单元格，表示一个单元格的位置、值和样式，但是并非实际创建的单元格
注意：虚拟单元格设置值和样式均不会在实际工作簿中生效

Since:

6.0.0

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
VirtualCell(org.apache.poi.ss.usermodel.Cell cell, int x, int y) 构造
VirtualCell(org.apache.poi.ss.usermodel.Cell cell, int x, int y, Object value) 构造
VirtualCell(org.apache.poi.ss.usermodel.Row row, int x, int y) 构造

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.util.CellRangeAddress	getArrayFormulaRange()
boolean	getBooleanCellValue()
org.apache.poi.ss.usermodel.CellType	getCachedFormulaResultType()
org.apache.poi.ss.usermodel.Comment	getCellComment()
String	getCellFormula()
org.apache.poi.ss.usermodel.CellStyle	getCellStyle()
org.apache.poi.ss.usermodel.CellType	getCellType()
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()
protected org.apache.poi.ss.SpreadsheetVersion	getSpreadsheetVersion()
String	getStringCellValue()
boolean	isPartOfArrayFormulaGroup()
void	removeCellComment()
protected void	removeFormulaImpl()
void	removeHyperlink()
void	setAsActiveCell()
void	setCellComment(org.apache.poi.ss.usermodel.Comment comment)
void	setCellErrorValue(byte value)
protected void	setCellFormulaImpl(String formula)
void	setCellStyle(org.apache.poi.ss.usermodel.CellStyle style)
protected void	setCellTypeImpl(org.apache.poi.ss.usermodel.CellType cellType)
void	setCellValue(boolean value)
protected void	setCellValueImpl(Calendar value)
protected void	setCellValueImpl(Date value)
protected void	setCellValueImpl(double value)
protected void	setCellValueImpl(LocalDateTime value)
protected void	setCellValueImpl(org.apache.poi.ss.usermodel.RichTextString value)
protected void	setCellValueImpl(String value)
void	setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)

Methods inherited from class org.apache.poi.ss.usermodel.CellBase

getAddress, getValueType, removeFormula, setBlank, setCellFormula, setCellType, setCellValue, setCellValue, setCellValue, setCellValue, setCellValue, setCellValue, tryToDeleteArrayFormula

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

VirtualCell

public VirtualCell(org.apache.poi.ss.usermodel.Cell cell,
                   int x,
                   int y)

构造

Parameters:

cell - 参照单元格

x - 新的列号，从0开始

y - 新的行号，从0开始

VirtualCell

public VirtualCell(org.apache.poi.ss.usermodel.Cell cell,
                   int x,
                   int y,
                   Object value)

构造

Parameters:

cell - 参照单元格

x - 新的列号，从0开始

y - 新的行号，从0开始

value - 新值

VirtualCell

public VirtualCell(org.apache.poi.ss.usermodel.Row row,
                   int x,
                   int y)

构造

Parameters:

row - 行

y - 行号，从0开始

x - 列号，从0开始

Method Detail

setCellTypeImpl

protected void setCellTypeImpl(org.apache.poi.ss.usermodel.CellType cellType)

Specified by:

setCellTypeImpl in class org.apache.poi.ss.usermodel.CellBase

setCellFormulaImpl

protected void setCellFormulaImpl(String formula)

Specified by:

setCellFormulaImpl in class org.apache.poi.ss.usermodel.CellBase

removeFormulaImpl

protected void removeFormulaImpl()

Specified by:

removeFormulaImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(double value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(Date value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(LocalDateTime value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(Calendar value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(String value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

setCellValueImpl

protected void setCellValueImpl(org.apache.poi.ss.usermodel.RichTextString value)

Specified by:

setCellValueImpl in class org.apache.poi.ss.usermodel.CellBase

getSpreadsheetVersion

protected org.apache.poi.ss.SpreadsheetVersion getSpreadsheetVersion()

Specified by:

getSpreadsheetVersion in class org.apache.poi.ss.usermodel.CellBase

getColumnIndex

public int getColumnIndex()

getRowIndex

public int getRowIndex()

getSheet

public org.apache.poi.ss.usermodel.Sheet getSheet()

getRow

public org.apache.poi.ss.usermodel.Row getRow()

getCellType

public org.apache.poi.ss.usermodel.CellType getCellType()

getCachedFormulaResultType

public org.apache.poi.ss.usermodel.CellType getCachedFormulaResultType()

getCellFormula

public String getCellFormula()

getNumericCellValue

public double getNumericCellValue()

getDateCellValue

public Date getDateCellValue()

getLocalDateTimeCellValue

public LocalDateTime getLocalDateTimeCellValue()

getRichStringCellValue

public org.apache.poi.ss.usermodel.RichTextString getRichStringCellValue()

getStringCellValue

public String getStringCellValue()

setCellValue

public void setCellValue(boolean value)

setCellErrorValue

public void setCellErrorValue(byte value)

getBooleanCellValue

public boolean getBooleanCellValue()

getErrorCellValue

public byte getErrorCellValue()

setCellStyle

public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle style)

getCellStyle

public org.apache.poi.ss.usermodel.CellStyle getCellStyle()

setAsActiveCell

public void setAsActiveCell()

setCellComment

public void setCellComment(org.apache.poi.ss.usermodel.Comment comment)

getCellComment

public org.apache.poi.ss.usermodel.Comment getCellComment()

removeCellComment

public void removeCellComment()

getHyperlink

public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()

setHyperlink

public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink link)

removeHyperlink

public void removeHyperlink()

getArrayFormulaRange

public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()

isPartOfArrayFormulaGroup

public boolean isPartOfArrayFormulaGroup()