br.com.tecsinapse.exporter

Class Table

java.lang.Object

br.com.tecsinapse.exporter.Table

public class Table
extends Object

Constructor Summary

Constructors

Constructor and Description
Table()

Method Summary

Methods

Modifier and Type	Method and Description
void	add(Number content)
void	add(Number content, boolean bold)
void	add(String content)
void	add(String content, boolean bold)
void	add(String content, CellType cellType)
void	add(String content, ContentType contentType)
void	add(String content, int colspan)
void	add(String content, int colspan, int rowspan)
void	add(String content, String style)
void	add(String content, String style, int colspan)
void	add(String content, String style, int colspan, int rowspan)
void	add(String content, TableCellType tableCellType)
void	add(String content, TableCellType tableCellType, boolean bold)
void	add(String content, TableCellType cellType, ContentType contentType)
void	add(String content, TableCellType tableCellType, int colspan)
void	add(String content, TableCellType tableCellType, int colspan, int rowspan)
void	add(String content, TableCellType tableCellType, String style, int colspan)
void	add(String content, TableCellType tableCellType, String style, 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()
TableCell	getLastCell()
String	getLastCellContent()
Integer	getLastColumnIndex(List<TableCell> row)
List<TableCell>	getLastRow()
Integer	getLastRowIndex()
int	getNextColumnIndexOfLastRow()
String	getStringMatrixAsString(List<List<String>> matrix)
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.
void	printString()
void	printStringMatrix(List<List<String>> matrix)
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	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() Deprecated. use Workbook toHSSFWorkBook() instead.
org.apache.poi.ss.usermodel.Workbook	toWorkBook(org.apache.poi.ss.usermodel.Workbook wb)
org.apache.poi.ss.usermodel.Workbook	toXSSFWorkBook()

Methods inherited from class java.lang.Object

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

Constructor Detail

Table

public Table()

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(String content)

add

public void add(String content,
       boolean bold)

add

public void add(String content,
       TableCellType tableCellType)

add

public void add(String content,
       TableCellType tableCellType,
       boolean bold)

add

public void add(String content,
       TableCellType tableCellType,
       int colspan)

add

public void add(String content,
       TableCellType tableCellType,
       int colspan,
       int rowspan)

add

public void add(String content,
       TableCellType tableCellType,
       String style,
       int colspan)

add

public void add(String content,
       TableCellType tableCellType,
       String style,
       int colspan,
       int rowspan)

add

public void add(String content,
       String style)

add

public void add(String content,
       String style,
       int colspan)

add

public void add(String content,
       String style,
       int colspan,
       int rowspan)

add

public void add(String content,
       int colspan)

add

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

add

public void add(String content,
       CellType cellType)

add

public void add(String content,
       TableCellType cellType,
       ContentType contentType)

add

public void add(String content,
       ContentType contentType)

add

public void add(Number content)

add

public void add(Number content,
       boolean bold)

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()

printStringMatrix

public void printStringMatrix(List<List<String>> matrix)

getStringMatrixAsString

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

printString

public void printString()

toXSSFWorkBook

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

toHSSFWorkBook

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

toWorkBook

@Deprecated
public org.apache.poi.ss.usermodel.Workbook toWorkBook()

Deprecated. use Workbook toHSSFWorkBook() instead.

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

setAutoSizeColumnSheet

public void setAutoSizeColumnSheet(boolean autoSizeColumnSheet)