public final class BookHelper extends Object
Modifier and Type | Field and 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 and Description |
---|
BookHelper() |
Modifier and Type | Method and 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) |
public static final String AUTO_COLOR
public static final int SORT_NORMAL_DEFAULT
public static final int SORT_TEXT_AS_NUMBERS
public static final int SORT_HEADER_NO
public static final int SORT_HEADER_YES
public static int getRowFreeze(Sheet sheet)
public static int getColumnFreeze(Sheet sheet)
public static boolean isFreezePane(Sheet sheet)
public static byte[] getRgbWithSchemeTint(byte[] rgb, double tint)
public static byte[] getRgbWithSchemeShade(byte[] rgb, double shade)
public static byte[] getRgbWithSchemeHueMod(byte[] rgb, double hueMod)
public static byte[] getRgbWithSchemeSat(byte[] rgb, double newSat)
public static byte[] getRgbWithSchemeSatOff(byte[] rgb, double satOff)
public static byte[] getRgbWithSchemeSatMod(byte[] rgb, double satMod)
public static byte[] getRgbWithSchemeLum(byte[] rgb, double newLum)
public static byte[] getRgbWithSchemeLumOff(byte[] rgb, double lumOff)
public static byte[] getRgbWithSchemeLumMod(byte[] rgb, double lumMod)
public static byte[] getRgbWithTint(byte[] rgb, double tint)
public static String toHex(int num)
public static void setFillForegroundColor(CellStyle newCellStyle, Color xlsColor)
public static void setFillBackgroundColor(CellStyle newCellStyle, Color xlsColor)
Copyright © 2023. All rights reserved.