org.opengts.util
Interface ExcelAPI

All Known Implementing Classes:

ExcelTools.Spreadsheet

public interface ExcelAPI

Field Summary

static int	CellStyle_ALIGN_CENTER
static int	CellStyle_ALIGN_LEFT
static int	CellStyle_ALIGN_RIGHT
static int	CellStyle_BORDER_NONE
static int	CellStyle_BORDER_THICK
static int	CellStyle_BORDER_THIN
static int	CellStyle_SOLID_FOREGROUND
static int	CellStyle_VERTICAL_BOTTOM
static int	CellStyle_VERTICAL_CENTER
static int	CellStyle_VERTICAL_TOP
static int	Font_BOLDWEIGHT_BOLD
static int	Font_BOLDWEIGHT_NORMAL
static int	Font_POINT_10
static int	Font_POINT_11
static int	Font_POINT_12
static int	Font_POINT_14
static int	Font_POINT_16
static int	Font_POINT_18
static int	Font_POINT_20
static int	Font_POINT_9
static boolean	Text_NOWRAP
static boolean	Text_WRAP

Method Summary

void	addBodyColumn(int rowIndex, int colIndex, java.lang.Object value)
void	addHeaderColumn(int rowIndex, int colIndex, int colSpan, java.lang.String colTitle, int charWidth)
void	addHeaderColumn(int rowIndex, int colIndex, java.lang.String colTitle, int charWidth)
void	addSubtotalColumn(int rowIndex, int colIndex, java.lang.Object value)
void	addTotalColumn(int rowIndex, int colIndex, java.lang.Object value)
void	init(boolean xlsx, java.lang.String name)
void	setBlankRow(int rowIndex, int colSpan)
void	setSubtitle(int rowIndex, java.lang.String title, int colSpan)
void	setTitle(int rowIndex, java.lang.String title, int colSpan)
boolean	write(java.io.File dir)
boolean	write(java.io.OutputStream out)

Field Detail

CellStyle_ALIGN_LEFT

static final int CellStyle_ALIGN_LEFT

See Also:

Constant Field Values

CellStyle_ALIGN_CENTER

static final int CellStyle_ALIGN_CENTER

See Also:

Constant Field Values

CellStyle_ALIGN_RIGHT

static final int CellStyle_ALIGN_RIGHT

See Also:

Constant Field Values

CellStyle_VERTICAL_TOP

static final int CellStyle_VERTICAL_TOP

See Also:

Constant Field Values

CellStyle_VERTICAL_CENTER

static final int CellStyle_VERTICAL_CENTER

See Also:

Constant Field Values

CellStyle_VERTICAL_BOTTOM

static final int CellStyle_VERTICAL_BOTTOM

See Also:

Constant Field Values

CellStyle_SOLID_FOREGROUND

static final int CellStyle_SOLID_FOREGROUND

See Also:

Constant Field Values

CellStyle_BORDER_NONE

static final int CellStyle_BORDER_NONE

See Also:

Constant Field Values

CellStyle_BORDER_THIN

static final int CellStyle_BORDER_THIN

See Also:

Constant Field Values

CellStyle_BORDER_THICK

static final int CellStyle_BORDER_THICK

See Also:

Constant Field Values

Font_BOLDWEIGHT_BOLD

static final int Font_BOLDWEIGHT_BOLD

See Also:

Constant Field Values

Font_BOLDWEIGHT_NORMAL

static final int Font_BOLDWEIGHT_NORMAL

See Also:

Constant Field Values

Font_POINT_9

static final int Font_POINT_9

See Also:

Constant Field Values

Font_POINT_10

static final int Font_POINT_10

See Also:

Constant Field Values

Font_POINT_11

static final int Font_POINT_11

See Also:

Constant Field Values

Font_POINT_12

static final int Font_POINT_12

See Also:

Constant Field Values

Font_POINT_14

static final int Font_POINT_14

See Also:

Constant Field Values

Font_POINT_16

static final int Font_POINT_16

See Also:

Constant Field Values

Font_POINT_18

static final int Font_POINT_18

See Also:

Constant Field Values

Font_POINT_20

static final int Font_POINT_20

See Also:

Constant Field Values

Text_WRAP

static final boolean Text_WRAP

See Also:

Constant Field Values

Text_NOWRAP

static final boolean Text_NOWRAP

See Also:

Constant Field Values

Method Detail

init

void init(boolean xlsx,
          java.lang.String name)

setTitle

void setTitle(int rowIndex,
              java.lang.String title,
              int colSpan)

setSubtitle

void setSubtitle(int rowIndex,
                 java.lang.String title,
                 int colSpan)

setBlankRow

void setBlankRow(int rowIndex,
                 int colSpan)

addHeaderColumn

void addHeaderColumn(int rowIndex,
                     int colIndex,
                     java.lang.String colTitle,
                     int charWidth)

addHeaderColumn

void addHeaderColumn(int rowIndex,
                     int colIndex,
                     int colSpan,
                     java.lang.String colTitle,
                     int charWidth)

addBodyColumn

void addBodyColumn(int rowIndex,
                   int colIndex,
                   java.lang.Object value)

addSubtotalColumn

void addSubtotalColumn(int rowIndex,
                       int colIndex,
                       java.lang.Object value)

addTotalColumn

void addTotalColumn(int rowIndex,
                    int colIndex,
                    java.lang.Object value)

write

boolean write(java.io.File dir)

write

boolean write(java.io.OutputStream out)