com.sh.common.util

类 ExcelStyle

java.lang.Object

com.sh.common.util.ExcelStyle

public class ExcelStyle
extends java.lang.Object

Description: Excel样式

Title:首亨软件 - TSS/CRM等

从以下版本开始:

Jun 27, 2012

版本:

3.0

作者:

江兴春

构造器概要

构造器

构造器和说明
ExcelStyle()

方法概要

限定符和类型	方法和说明
static jxl.write.WritableCellFormat	getDefaultHeaderStyle() 默认表头样式
static jxl.write.WritableCellFormat	getDefaultHeaderStyle(jxl.format.Colour c) 默认表头样式
static jxl.write.WritableCellFormat	getDefaultStyle() 默认样式
static jxl.write.WritableCellFormat	getStyle(jxl.format.Alignment a)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Alignment a, jxl.format.BorderLineStyle b)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Alignment a, jxl.format.Colour c)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Alignment a, jxl.format.VerticalAlignment v)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Alignment a, jxl.format.VerticalAlignment v, jxl.format.Colour c, jxl.format.BorderLineStyle b) 获取样式
static jxl.write.WritableCellFormat	getStyle(jxl.format.BorderLineStyle b)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Colour c)
static jxl.write.WritableCellFormat	getStyle(jxl.format.Colour c, jxl.format.BorderLineStyle b)
static jxl.write.WritableCellFormat	getStyle(jxl.format.VerticalAlignment v)
static jxl.write.WritableCellFormat	getStyle(jxl.format.VerticalAlignment v, jxl.format.BorderLineStyle b)
static jxl.write.WritableCellFormat	getStyle(jxl.format.VerticalAlignment v, jxl.format.Colour c)

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

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

构造器详细资料

ExcelStyle

public ExcelStyle()

方法详细资料

getDefaultHeaderStyle

public static jxl.write.WritableCellFormat getDefaultHeaderStyle(jxl.format.Colour c)

默认表头样式

参数:

c - 背景色

返回:

WritableCellFormat

getDefaultHeaderStyle

public static jxl.write.WritableCellFormat getDefaultHeaderStyle()

默认表头样式

返回:

WritableCellFormat

getDefaultStyle

public static jxl.write.WritableCellFormat getDefaultStyle()

默认样式

返回:

WritableCellFormat

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Alignment a,
                                                    jxl.format.VerticalAlignment v,
                                                    jxl.format.Colour c,
                                                    jxl.format.BorderLineStyle b)

获取样式

参数:

a - 水平对齐方式

v - 垂直对齐方式

c - 背景色

b - BorderLineStyle

返回:

WritableCellFormat

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Alignment a)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.VerticalAlignment v)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Colour c)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.BorderLineStyle b)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Alignment a,
                                                    jxl.format.VerticalAlignment v)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Alignment a,
                                                    jxl.format.Colour c)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Alignment a,
                                                    jxl.format.BorderLineStyle b)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.VerticalAlignment v,
                                                    jxl.format.Colour c)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.VerticalAlignment v,
                                                    jxl.format.BorderLineStyle b)

getStyle

public static jxl.write.WritableCellFormat getStyle(jxl.format.Colour c,
                                                    jxl.format.BorderLineStyle b)