org.zkoss.zss.range.impl.imexp

Class BookHelper

java.lang.Object

org.zkoss.zss.range.impl.imexp.BookHelper

public final class BookHelper
extends java.lang.Object

Helper for XSSF and HSSF book handling

Author:

Hawk, Kuro

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	AUTO_COLOR
static int	SORT_HEADER_NO
static int	SORT_HEADER_YES
static int	SORT_NORMAL_DEFAULT
static int	SORT_TEXT_AS_NUMBERS

Constructor Summary

Constructors

Constructor and Description
BookHelper()

Method Summary

Modifier and Type	Method and Description
static java.lang.String	colorToBackgroundHTML(Workbook book, Color color)
static java.lang.String	colorToBorderHTML(Workbook book, Color color)
static java.lang.String	colorToForegroundHTML(Workbook book, Color color)
static java.lang.String	colorToHTML(Workbook book, Color color)
static int	getColumnFreeze(Sheet sheet) gets the column freeze, 1 base
static java.lang.String	getFontHTMLColor(Workbook book, Font font)
static int	getRowFreeze(Sheet sheet) gets the row freeze, 1 base
static Color	HTMLToColor(Workbook book, java.lang.String color)
static boolean	isFreezePane(Sheet sheet)
static void	setBottomBorderColor(CellStyle style, Color color)
static void	setFillBackgroundColor(CellStyle newCellStyle, Color xlsColor)
static void	setFillForegroundColor(CellStyle newCellStyle, Color xlsColor)
static void	setFontColor(Workbook book, Font font, Color color)
static void	setLeftBorderColor(CellStyle style, Color color)
static void	setRightBorderColor(CellStyle style, Color color)
static void	setTopBorderColor(CellStyle style, Color color)
static java.lang.String	toHex(int num)

Methods inherited from class java.lang.Object

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

Field Detail

AUTO_COLOR

public static final java.lang.String AUTO_COLOR

See Also:

Constant Field Values

SORT_NORMAL_DEFAULT

public static final int SORT_NORMAL_DEFAULT

See Also:

Constant Field Values

SORT_TEXT_AS_NUMBERS

public static final int SORT_TEXT_AS_NUMBERS

See Also:

Constant Field Values

SORT_HEADER_NO

public static final int SORT_HEADER_NO

See Also:

Constant Field Values

SORT_HEADER_YES

public static final int SORT_HEADER_YES

See Also:

Constant Field Values

Constructor Detail

BookHelper

public BookHelper()

Method Detail

getRowFreeze

public static int getRowFreeze(Sheet sheet)

gets the row freeze, 1 base

getColumnFreeze

public static int getColumnFreeze(Sheet sheet)

gets the column freeze, 1 base

isFreezePane

public static boolean isFreezePane(Sheet sheet)

getFontHTMLColor

public static java.lang.String getFontHTMLColor(Workbook book,
                                                Font font)

colorToHTML

public static java.lang.String colorToHTML(Workbook book,
                                           Color color)

colorToBorderHTML

public static java.lang.String colorToBorderHTML(Workbook book,
                                                 Color color)

colorToForegroundHTML

public static java.lang.String colorToForegroundHTML(Workbook book,
                                                     Color color)

colorToBackgroundHTML

public static java.lang.String colorToBackgroundHTML(Workbook book,
                                                     Color color)

toHex

public static java.lang.String toHex(int num)

setLeftBorderColor

public static void setLeftBorderColor(CellStyle style,
                                      Color color)

setRightBorderColor

public static void setRightBorderColor(CellStyle style,
                                       Color color)

setTopBorderColor

public static void setTopBorderColor(CellStyle style,
                                     Color color)

setBottomBorderColor

public static void setBottomBorderColor(CellStyle style,
                                        Color color)

HTMLToColor

public static Color HTMLToColor(Workbook book,
                                java.lang.String color)

setFillForegroundColor

public static void setFillForegroundColor(CellStyle newCellStyle,
                                          Color xlsColor)

setFillBackgroundColor

public static void setFillBackgroundColor(CellStyle newCellStyle,
                                          Color xlsColor)

setFontColor

public static void setFontColor(Workbook book,
                                Font font,
                                Color color)