org.opengts.util
Class ExcelTools

java.lang.Object
  org.opengts.util.ExcelTools

public class ExcelTools
extends java.lang.Object

Nested Class Summary

static class

ExcelTools.Spreadsheet

Field Summary

static java.lang.String[]	ARG_XLS
static java.lang.String[]	ARG_XLSX
static int	IndexColor_BLACK
static int	IndexColor_GRAY25
static int	IndexColor_GRAY50
static int	IndexColor_NONE
static int	IndexColor_WHITE
static java.lang.String	PROP_ExcelTools_debug
static java.lang.String	STYLE_BLANK
static java.lang.String	STYLE_BODY
static java.lang.String	STYLE_HEADER
static java.lang.String	STYLE_SUBTITLE
static java.lang.String	STYLE_SUBTOTAL
static java.lang.String	STYLE_TITLE
static java.lang.String	STYLE_TOTAL

Constructor Summary

ExcelTools()

Method Summary

static org.apache.poi.ss.usermodel.CellStyle	createStyle(org.apache.poi.ss.usermodel.Workbook wb, int fontPoint, int boldWeight, int fontColor, int horzAlign, int vertAlign, boolean wrapText, int fillColor, int fillPattern, int borderTopColor, int borderRightColor, int borderBottomColor, int borderLeftColor)
static int	getColorIndex(java.lang.String name)
static void	main(java.lang.String[] argv)

Methods inherited from class java.lang.Object

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

Field Detail

PROP_ExcelTools_debug

public static final java.lang.String PROP_ExcelTools_debug

See Also:

Constant Field Values

IndexColor_NONE

public static final int IndexColor_NONE

See Also:

Constant Field Values

IndexColor_WHITE

public static final int IndexColor_WHITE

IndexColor_BLACK

public static final int IndexColor_BLACK

IndexColor_GRAY25

public static final int IndexColor_GRAY25

IndexColor_GRAY50

public static final int IndexColor_GRAY50

STYLE_TITLE

public static final java.lang.String STYLE_TITLE

See Also:

Constant Field Values

STYLE_SUBTITLE

public static final java.lang.String STYLE_SUBTITLE

See Also:

Constant Field Values

STYLE_HEADER

public static final java.lang.String STYLE_HEADER

See Also:

Constant Field Values

STYLE_BODY

public static final java.lang.String STYLE_BODY

See Also:

Constant Field Values

STYLE_SUBTOTAL

public static final java.lang.String STYLE_SUBTOTAL

See Also:

Constant Field Values

STYLE_TOTAL

public static final java.lang.String STYLE_TOTAL

See Also:

Constant Field Values

STYLE_BLANK

public static final java.lang.String STYLE_BLANK

See Also:

Constant Field Values

ARG_XLS

public static java.lang.String[] ARG_XLS

ARG_XLSX

public static java.lang.String[] ARG_XLSX

Constructor Detail

ExcelTools

public ExcelTools()

Method Detail

getColorIndex

public static int getColorIndex(java.lang.String name)

createStyle

public static org.apache.poi.ss.usermodel.CellStyle createStyle(org.apache.poi.ss.usermodel.Workbook wb,
                                                                int fontPoint,
                                                                int boldWeight,
                                                                int fontColor,
                                                                int horzAlign,
                                                                int vertAlign,
                                                                boolean wrapText,
                                                                int fillColor,
                                                                int fillPattern,
                                                                int borderTopColor,
                                                                int borderRightColor,
                                                                int borderBottomColor,
                                                                int borderLeftColor)

main

public static void main(java.lang.String[] argv)