com.sh.common.excel

类 ExcelCell

java.lang.Object

com.sh.common.excel.ExcelCell

public class ExcelCell
extends java.lang.Object

Description: Excel单元格 Title:首亨软件 - CRM、TSS、ERP等信息化管理软件

版本:

1.0

作者:

江兴春

字段概要

字段

限定符和类型	字段和说明
static int	DOUBLE
static int	STRING
static int	TIMESTAMP

构造器概要

构造器

构造器和说明
ExcelCell(int cellType, java.lang.String tableCol, java.lang.String desc)
ExcelCell(java.lang.String tableCol)
ExcelCell(java.lang.String desc, java.lang.String tableCol)

方法概要

限定符和类型	方法和说明
ExcelCell	createDoubleCell(java.lang.String numberFormat) 构造Double型列
ExcelCell	createTimestampCell(java.lang.String dateFormat) 构造Timestamp型列
java.lang.String	getBodyAttribute()
java.lang.String	getBodyStyleId()
int	getCellType()
java.lang.String	getDateFormat()
java.lang.String	getDesc()
java.lang.String	getHeaderAttribute()
java.lang.String	getHeaderStyleId()
java.lang.String	getNumberFormat()
java.lang.String	getTableCol()
boolean	isNumeric()
boolean	isString()
boolean	isTimestamp()
ExcelCell	setBodyAttribute(java.lang.String bodyAttribute)
ExcelCell	setBodyStyleId(java.lang.String bodyStyleId) 设置单元格样式
ExcelCell	setCellType(int cellType)
ExcelCell	setDateFormat(java.lang.String dateFormat)
ExcelCell	setDesc(java.lang.String desc)
ExcelCell	setHeaderAttribute(java.lang.String headerAttribute)
ExcelCell	setHeaderStyleId(java.lang.String headerStyleId) 设置表头样式
ExcelCell	setNumberFormat(java.lang.String numberFormat)
ExcelCell	setTableCol(java.lang.String tableCol)

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

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

DOUBLE

public static int DOUBLE

STRING

public static int STRING

TIMESTAMP

public static int TIMESTAMP

构造器详细资料

ExcelCell

public ExcelCell(int cellType,
                 java.lang.String tableCol,
                 java.lang.String desc)

ExcelCell

public ExcelCell(java.lang.String desc,
                 java.lang.String tableCol)

ExcelCell

public ExcelCell(java.lang.String tableCol)

方法详细资料

createDoubleCell

public ExcelCell createDoubleCell(java.lang.String numberFormat)

构造Double型列

参数:

numberFormat - String

返回:

ExcelCell

createTimestampCell

public ExcelCell createTimestampCell(java.lang.String dateFormat)

构造Timestamp型列

参数:

dateFormat - String

返回:

ExcelCell

getCellType

public int getCellType()

setCellType

public ExcelCell setCellType(int cellType)

getDesc

public java.lang.String getDesc()

setDesc

public ExcelCell setDesc(java.lang.String desc)

isNumeric

public boolean isNumeric()

isTimestamp

public boolean isTimestamp()

isString

public boolean isString()

getNumberFormat

public java.lang.String getNumberFormat()

setNumberFormat

public ExcelCell setNumberFormat(java.lang.String numberFormat)

getDateFormat

public java.lang.String getDateFormat()

setDateFormat

public ExcelCell setDateFormat(java.lang.String dateFormat)

getTableCol

public java.lang.String getTableCol()

setTableCol

public ExcelCell setTableCol(java.lang.String tableCol)

getBodyStyleId

public java.lang.String getBodyStyleId()

setBodyStyleId

public ExcelCell setBodyStyleId(java.lang.String bodyStyleId)

设置单元格样式

参数:

bodyStyleId - String

返回:

ExcelCell

getHeaderStyleId

public java.lang.String getHeaderStyleId()

setHeaderStyleId

public ExcelCell setHeaderStyleId(java.lang.String headerStyleId)

设置表头样式

参数:

headerStyleId - String

返回:

ExcelCell

getHeaderAttribute

public java.lang.String getHeaderAttribute()

setHeaderAttribute

public ExcelCell setHeaderAttribute(java.lang.String headerAttribute)

getBodyAttribute

public java.lang.String getBodyAttribute()

setBodyAttribute

public ExcelCell setBodyAttribute(java.lang.String bodyAttribute)