Package com.amalgamasimulation.excel

Class ExcelFile

java.lang.Object

com.amalgamasimulation.excel.DataStorage<ExcelTable<?>>

com.amalgamasimulation.excel.ExcelFile

public class ExcelFile
extends DataStorage<ExcelTable<?>>

ExcelFile allow you to save tabead data and cahrts to Excel file. It contains a set of ExcelTable that represent an a tabled data and set of chart. This class also store all CellStyle for applay it in really fast way. This calss use apache POI for interractiong with Excel, and предоставляет доступ к XSSFWorkbook for manual operation with it. POIXMLProperties - может стоит написать get/set и упомянуть тут

Author:

Vitaliy

Field Summary

Fields inherited from class com.amalgamasimulation.excel.DataStorage

sheetToTables, tables

Constructor Summary

Constructors

Constructor	Description
ExcelFile()

Method Summary

Modifier and Type	Method	Description
ExcelBarChart	addBarChart(String sheetName, int topRow, int leftColumn, int bottomRow, int rightColumn)
ExcelFile	addCustomProperty(String name, String value)
ExcelLineChart	addLineChart(String sheetName, int topRow, int leftColumn, int bottomRow, int rightColumn)
<E> ExcelTable<E>	addTable(String sheetName, List<E> elements)
protected <E> ExcelTable<E>	createTable(String sheetName, int row, int column, List<E> elements, boolean isAutoSizeColumns)
ExcelTableColumn<?,?>	getTableColumn(String sheetName, String columnName)
org.apache.poi.xssf.usermodel.XSSFWorkbook	getWorkbook()
boolean	write(OutputStream stream)
boolean	write(OutputStream stream, Supplier<Boolean> interrupt)
boolean	write(String filePath)
boolean	write(String filePath, Supplier<Boolean> interrupt)

Methods inherited from class com.amalgamasimulation.excel.DataStorage

addTable, addTable

Methods inherited from class java.lang.Object

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

Constructor Details

ExcelFile

public ExcelFile()

Method Details

getWorkbook

public org.apache.poi.xssf.usermodel.XSSFWorkbook getWorkbook()

createTable

protected <E> ExcelTable<E> createTable(String sheetName,
 int row,
 int column,
 List<E> elements,
 boolean isAutoSizeColumns)

Specified by:

createTable in class DataStorage<ExcelTable<?>>

addTable

public <E> ExcelTable<E> addTable(String sheetName,
 List<E> elements)

Overrides:

addTable in class DataStorage<ExcelTable<?>>

addCustomProperty

public ExcelFile addCustomProperty(String name,
 String value)

addLineChart

public ExcelLineChart addLineChart(String sheetName,
 int topRow,
 int leftColumn,
 int bottomRow,
 int rightColumn)

addBarChart

public ExcelBarChart addBarChart(String sheetName,
 int topRow,
 int leftColumn,
 int bottomRow,
 int rightColumn)

write

public boolean write(OutputStream stream)

write

public boolean write(OutputStream stream,
 Supplier<Boolean> interrupt)

write

public boolean write(String filePath)

write

public boolean write(String filePath,
 Supplier<Boolean> interrupt)

getTableColumn

public ExcelTableColumn<?,?> getTableColumn(String sheetName,
 String columnName)