org.opengts.util
Class ExcelTools.Spreadsheet

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

All Implemented Interfaces:

ExcelAPI

Enclosing class:

ExcelTools

public static class ExcelTools.Spreadsheet
extends java.lang.Object
implements ExcelAPI

Field Summary

Fields inherited from interface org.opengts.util.ExcelAPI

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

Constructor Summary

ExcelTools.Spreadsheet()

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	autoSizeColumns()
java.lang.String	getExtension()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
void	init(boolean xlsx, java.lang.String name)
boolean	isDebugLogging()
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)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelTools.Spreadsheet

public ExcelTools.Spreadsheet()

Method Detail

isDebugLogging

public boolean isDebugLogging()

init

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

Specified by:

init in interface ExcelAPI

setTitle

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

Specified by:

setTitle in interface ExcelAPI

setSubtitle

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

Specified by:

setSubtitle in interface ExcelAPI

setBlankRow

public void setBlankRow(int rowIndex,
                        int colSpan)

Specified by:

setBlankRow in interface ExcelAPI

addHeaderColumn

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

Specified by:

addHeaderColumn in interface ExcelAPI

addHeaderColumn

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

Specified by:

addHeaderColumn in interface ExcelAPI

addBodyColumn

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

Specified by:

addBodyColumn in interface ExcelAPI

addSubtotalColumn

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

Specified by:

addSubtotalColumn in interface ExcelAPI

addTotalColumn

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

Specified by:

addTotalColumn in interface ExcelAPI

autoSizeColumns

public void autoSizeColumns()

getWorkbook

public org.apache.poi.ss.usermodel.Workbook getWorkbook()

getExtension

public java.lang.String getExtension()

write

public boolean write(java.io.File dir)

Specified by:

write in interface ExcelAPI

write

public boolean write(java.io.OutputStream out)

Specified by:

write in interface ExcelAPI