com.sh.module.page.util.excel

类 ExcelStyle

java.lang.Object

com.sh.module.page.util.excel.ExcelStyle

public class ExcelStyle
extends java.lang.Object

Description: Excel样式

Title:首亨软件 - TSS/CRM等

从以下版本开始:

Nov 9, 2012

版本:

3.0

作者:

江兴春

构造器概要

构造器

构造器和说明
ExcelStyle()
ExcelStyle(jxl.write.NumberFormat jxlNumberFormat)

方法概要

限定符和类型	方法和说明
jxl.write.WritableCellFormat	getCellFormat() 获取样式
ExcelStyle	setBackground(jxl.format.Colour c) 背景色
ExcelStyle	setBackground(ExcelColour c) 背景色
ExcelStyle	setCenter() 居中
ExcelStyle	setLeft() 左对齐
ExcelStyle	setNumberFormat(java.lang.String formatStr) 数字单元格格式化
ExcelStyle	setRight() 右对齐
ExcelStyle	setVBottom() 下对齐
ExcelStyle	setVCenter() 样式居中表达式
ExcelStyle	setVTop() 上对齐

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

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

构造器详细资料

ExcelStyle

public ExcelStyle()

ExcelStyle

public ExcelStyle(jxl.write.NumberFormat jxlNumberFormat)

方法详细资料

getCellFormat

public jxl.write.WritableCellFormat getCellFormat()

获取样式

返回:

WritableCellFormat

setVCenter

public ExcelStyle setVCenter()
                      throws jxl.write.WriteException

样式居中表达式

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setVTop

public ExcelStyle setVTop()
                   throws jxl.write.WriteException

上对齐

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setVBottom

public ExcelStyle setVBottom()
                      throws jxl.write.WriteException

下对齐

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setLeft

public ExcelStyle setLeft()
                   throws jxl.write.WriteException

左对齐

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setCenter

public ExcelStyle setCenter()
                     throws jxl.write.WriteException

居中

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setRight

public ExcelStyle setRight()
                    throws jxl.write.WriteException

右对齐

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setBackground

public ExcelStyle setBackground(ExcelColour c)
                         throws jxl.write.WriteException

背景色

参数:

c - ExcelColour

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setBackground

public ExcelStyle setBackground(jxl.format.Colour c)
                         throws jxl.write.WriteException

背景色

参数:

c - Colour

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException

setNumberFormat

public ExcelStyle setNumberFormat(java.lang.String formatStr)
                           throws jxl.write.WriteException

数字单元格格式化

参数:

formatStr - String

返回:

ExcelStyle

抛出:

jxl.write.WriteException - WriteException