Package io.keikai.range.impl.imexp

Class BookHelper

java.lang.Object

io.keikai.range.impl.imexp.BookHelper

public final class BookHelper
extends Object

Helper for XSSF and HSSF book handling

Author:

Hawk, Kuro

Field Summary

Fields

Modifier and Type	Field	Description
static 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	Description
BookHelper()

Method Summary

Modifier and Type	Method	Description
static String	colorToBackgroundHTML(Workbook book, Color color)
static String	colorToBorderHTML(Workbook book, Color color)
static String	colorToForegroundHTML(Workbook book, Color color)
static String	colorToHTML(Workbook book, Color color)
static int	getColumnFreeze(Sheet sheet)	gets the column freeze, 1 base
static String	getFontHTMLColor(Workbook book, Font font)
static byte[]	getRgbWithSchemeHueMod(byte[] rgb, double hueMod)
static byte[]	getRgbWithSchemeLum(byte[] rgb, double newLum)
static byte[]	getRgbWithSchemeLumMod(byte[] rgb, double lumMod)
static byte[]	getRgbWithSchemeLumOff(byte[] rgb, double lumOff)
static byte[]	getRgbWithSchemeSat(byte[] rgb, double newSat)
static byte[]	getRgbWithSchemeSatMod(byte[] rgb, double satMod)
static byte[]	getRgbWithSchemeSatOff(byte[] rgb, double satOff)
static byte[]	getRgbWithSchemeShade(byte[] rgb, double shade)
static byte[]	getRgbWithSchemeTint(byte[] rgb, double tint)
static byte[]	getRgbWithTint(byte[] rgb, double tint)
static int	getRowFreeze(Sheet sheet)	gets the row freeze, 1 base
static Color	HTMLToColor(Workbook book, 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 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 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 String getFontHTMLColor(Workbook book,
                                      Font font)

colorToHTML

public static String colorToHTML(Workbook book,
                                 Color color)

colorToBorderHTML

public static String colorToBorderHTML(Workbook book,
                                       Color color)

colorToForegroundHTML

public static String colorToForegroundHTML(Workbook book,
                                           Color color)

colorToBackgroundHTML

public static String colorToBackgroundHTML(Workbook book,
                                           Color color)

getRgbWithSchemeTint

public static byte[] getRgbWithSchemeTint(byte[] rgb,
                                          double tint)

getRgbWithSchemeShade

public static byte[] getRgbWithSchemeShade(byte[] rgb,
                                           double shade)

getRgbWithSchemeHueMod

public static byte[] getRgbWithSchemeHueMod(byte[] rgb,
                                            double hueMod)

getRgbWithSchemeSat

public static byte[] getRgbWithSchemeSat(byte[] rgb,
                                         double newSat)

getRgbWithSchemeSatOff

public static byte[] getRgbWithSchemeSatOff(byte[] rgb,
                                            double satOff)

getRgbWithSchemeSatMod

public static byte[] getRgbWithSchemeSatMod(byte[] rgb,
                                            double satMod)

getRgbWithSchemeLum

public static byte[] getRgbWithSchemeLum(byte[] rgb,
                                         double newLum)

getRgbWithSchemeLumOff

public static byte[] getRgbWithSchemeLumOff(byte[] rgb,
                                            double lumOff)

getRgbWithSchemeLumMod

public static byte[] getRgbWithSchemeLumMod(byte[] rgb,
                                            double lumMod)

getRgbWithTint

public static byte[] getRgbWithTint(byte[] rgb,
                                    double tint)

toHex

public static 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,
                                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)