br.com.tecsinapse.dataio

Class Table

java.lang.Object

br.com.tecsinapse.dataio.Table

public class Table
extends Object

Constructor Summary

Constructors

Constructor and Description
Table()
Table(ExporterFormatter exporterFormatter)

Method Summary

Methods

Modifier and Type	Method and Description
void	add(Object content)
void	add(Object content, CellType cellType)
void	add(Object content, int colspan)
void	add(Object content, int colspan, int rowspan)
void	add(Object content, String cssStyle)
void	add(Object content, String cssStyle, int colspan)
void	add(Object content, String cssStyle, int colspan, int rowspan)
void	add(Object content, TableCellStyle tableCellStyle)
void	add(Object content, TableCellStyle tableCellStyle, int colspan)
void	add(Object content, TableCellStyle tableCellStyle, int colspan, int rowspan)
void	add(Object content, TableCellStyle tableCellStyle, String cssStyle, int colspan)
void	add(Object content, TableCellStyle tableCellStyle, String cssStyle, int colspan, int rowspan)
void	add(TableCell cell)
void	addAll(List<String> values)
void	addAll(List<TableCell> row, List<TableCell> values)
void	addAllCells(List<TableCell> values)
void	addNewRow()
void	addNewRow(List<TableCell> row)
void	addOnNewRow(TableCell cell)
void	addOnRow(TableCell cell, Integer row)
void	concatenateTableBelow(Table table)
void	concatenateTableOnRight(Table table)
List<List<TableCell>>	getCells()
ExporterFormatter	getExporterFormatter()
TableCell	getLastCell()
String	getLastCellContent()
Integer	getLastColumnIndex(List<TableCell> row)
List<TableCell>	getLastRow()
Integer	getLastRowIndex()
int	getMinOrMaxOrActualCellWidth(int value)
int	getNextColumnIndexOfLastRow()
String	getStringMatrixAsString(List<List<String>> matrix)
TableCellStyle	getTableCellStyleDefaultBody()
List<TableCellStyle>	getTableCellStyles()
String	getTitle()
boolean	isAutoSizeColumnSheet() Este método identifica se ao escrever as colunas da planilha deve ser utilizado o método autoSizeColumn do objeto org.apache.poi.ss.usermodel.Sheet.
org.apache.poi.hssf.util.HSSFColor	newCustomColor(org.apache.poi.hssf.util.HSSFColor replaceColor, Color newColor)
void	removeFirstRow()
void	removeInitialRows(int numberRows)
void	replace(TableCell cell, Integer row, Integer column)
void	replaceLastCell(TableCell cell)
void	replaceLastCellContent(String content)
void	replaceLastColumn(List<TableCell> row, TableCell cell)
void	setAutoSizeColumnSheet(boolean autoSizeColumnSheet)
void	setCells(List<List<TableCell>> cells)
void	setExporterFormatter(ExporterFormatter exporterFormatter)
void	setTableCellStyleDefaultBody(TableCellStyle tableCellStyleDefaultBody)
void	setTitle(String title)
org.apache.poi.ss.usermodel.Workbook	toHSSFWorkBook()
List<List<String>>	toStringMatrix()
List<List<TableCell>>	toTableCellMatrix()
org.apache.poi.ss.usermodel.Workbook	toWorkBook(org.apache.poi.ss.usermodel.Workbook wb)
org.apache.poi.ss.usermodel.Workbook	toXSSFWorkBook()
Table	withCell(Object content)
Table	withCell(Object content, TableCellStyle tableCellStyle)
Table	withCell(Object content, TableCellStyle tableCellStyle, int colspan)
Table	withCell(TableCell tableCell)
Table	withNewRow()

Methods inherited from class java.lang.Object

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

Constructor Detail

Table

public Table()

Table

public Table(ExporterFormatter exporterFormatter)

Method Detail

replace

public void replace(TableCell cell,
           Integer row,
           Integer column)

replaceLastCell

public void replaceLastCell(TableCell cell)

getLastCell

public TableCell getLastCell()

getLastCellContent

public String getLastCellContent()

replaceLastCellContent

public void replaceLastCellContent(String content)

replaceLastColumn

public void replaceLastColumn(List<TableCell> row,
                     TableCell cell)

getLastColumnIndex

public Integer getLastColumnIndex(List<TableCell> row)

getLastRowIndex

public Integer getLastRowIndex()

getLastRow

public List<TableCell> getLastRow()

addOnRow

public void addOnRow(TableCell cell,
            Integer row)

add

public void add(TableCell cell)

add

public void add(Object content)

add

public void add(Object content,
       TableCellStyle tableCellStyle)

add

public void add(Object content,
       TableCellStyle tableCellStyle,
       int colspan)

add

public void add(Object content,
       TableCellStyle tableCellStyle,
       int colspan,
       int rowspan)

add

public void add(Object content,
       TableCellStyle tableCellStyle,
       String cssStyle,
       int colspan)

add

public void add(Object content,
       TableCellStyle tableCellStyle,
       String cssStyle,
       int colspan,
       int rowspan)

add

public void add(Object content,
       String cssStyle)

add

public void add(Object content,
       int colspan)

add

public void add(Object content,
       int colspan,
       int rowspan)

add

public void add(Object content,
       String cssStyle,
       int colspan)

add

public void add(Object content,
       String cssStyle,
       int colspan,
       int rowspan)

add

public void add(Object content,
       CellType cellType)

addOnNewRow

public void addOnNewRow(TableCell cell)

addNewRow

public void addNewRow()

addNewRow

public void addNewRow(List<TableCell> row)

getCells

public List<List<TableCell>> getCells()

setCells

public void setCells(List<List<TableCell>> cells)

removeFirstRow

public void removeFirstRow()

removeInitialRows

public void removeInitialRows(int numberRows)

toStringMatrix

public List<List<String>> toStringMatrix()

toTableCellMatrix

public List<List<TableCell>> toTableCellMatrix()

getStringMatrixAsString

public String getStringMatrixAsString(List<List<String>> matrix)

toXSSFWorkBook

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

toHSSFWorkBook

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

toWorkBook

public org.apache.poi.ss.usermodel.Workbook toWorkBook(org.apache.poi.ss.usermodel.Workbook wb)

addAll

public void addAll(List<String> values)

addAllCells

public void addAllCells(List<TableCell> values)

addAll

public void addAll(List<TableCell> row,
          List<TableCell> values)

concatenateTableOnRight

public void concatenateTableOnRight(Table table)

concatenateTableBelow

public void concatenateTableBelow(Table table)

getTitle

public String getTitle()

setTitle

public void setTitle(String title)

getNextColumnIndexOfLastRow

public int getNextColumnIndexOfLastRow()

isAutoSizeColumnSheet

public boolean isAutoSizeColumnSheet()

Este método identifica se ao escrever as colunas da planilha deve ser utilizado o método autoSizeColumn do objeto org.apache.poi.ss.usermodel.Sheet.

Se retornar false as colunas serão redimencionadas realizando um cálculo considerando o maior número de caracteres existente em uma coluna

Returns:

true caso esteja configurado auto size. false caso contrário

setAutoSizeColumnSheet

public void setAutoSizeColumnSheet(boolean autoSizeColumnSheet)

getExporterFormatter

public ExporterFormatter getExporterFormatter()

setTableCellStyleDefaultBody

public void setTableCellStyleDefaultBody(TableCellStyle tableCellStyleDefaultBody)

getTableCellStyleDefaultBody

public TableCellStyle getTableCellStyleDefaultBody()

setExporterFormatter

public void setExporterFormatter(ExporterFormatter exporterFormatter)

withNewRow

public Table withNewRow()

withCell

public Table withCell(TableCell tableCell)

withCell

public Table withCell(Object content)

withCell

public Table withCell(Object content,
             TableCellStyle tableCellStyle)

withCell

public Table withCell(Object content,
             TableCellStyle tableCellStyle,
             int colspan)

getTableCellStyles

public List<TableCellStyle> getTableCellStyles()

newCustomColor

public org.apache.poi.hssf.util.HSSFColor newCustomColor(org.apache.poi.hssf.util.HSSFColor replaceColor,
                                                Color newColor)

getMinOrMaxOrActualCellWidth

public int getMinOrMaxOrActualCellWidth(int value)