Package com.storedobject.office

Class Excel

java.lang.Object

com.storedobject.core.StreamContentProducer

com.storedobject.office.AbstractSpreadSheet

com.storedobject.office.Excel

All Implemented Interfaces:

Executable, ContentProducer, ContentType, Closeable, AutoCloseable, Runnable

Direct Known Subclasses:

ExcelReport

public class Excel
extends AbstractSpreadSheet

Field Summary

Fields inherited from class com.storedobject.office.AbstractSpreadSheet

MAX_ROWS, workbook

Fields inherited from class com.storedobject.core.StreamContentProducer

out

Constructor Summary

Constructors

Constructor	Description
Excel()	Constructor.
Excel(FileData fileData)	Constructor.
Excel(Id templateId)	Constructor
Excel(Id templateId, OutputStream out)	Constructor
Excel(StreamData streamData)	Constructor
Excel(StreamData streamData, OutputStream out)	Constructor
Excel(InputStream in)	Constructor.
Excel(InputStream in, OutputStream out)	Constructor.
Excel(OutputStream out)	Constructor.
Excel(String databaseFileName)	Constructor.

Method Summary

Modifier and Type	Method	Description
protected org.apache.poi.ss.usermodel.Workbook	createWorkbook(InputStream in)
String	getContentType()
String	getFileExtension()
void	recompute()	Re-evaluate all formula in the worksheet.

Methods inherited from class com.storedobject.office.AbstractSpreadSheet

abort, close, generateContent, getCell, getCell, getCell, getCell, getCellIndex, getCells, getCenteredStyle, getColumnCells, getDateStyle, getDateTimeStyle, getDevice, getHourStyle, getNextCell, getNextRow, getNextSheet, getNumericStyle, getNumericStyle, getPercentage2Style, getPercentageStyle, getPreviousCell, getPreviousRow, getPreviousSheet, getRightAlignedStyle, getRow, getRow, getRow, getRowCells, getRowIndex, getSheet, getSheet, getSheetIndex, getWorkbook, goToCell, goToCell, goToCell, goToCell, goToRow, isSameSize, moveDown, moveLeft, moveRight, moveUp, save, save, setCellValue, setCellValue, setCellValues, validateCellAddress, validateColumnAddress, validateRangeAddress, validateRowAddress

Methods inherited from class com.storedobject.core.StreamContentProducer

getContent, getError, getFileName, getTransactionManager, getWriter, produce, setTransactionManager

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.storedobject.core.ContentProducer

execute, extractContent, getEntity, getStreamData, getStreamDataProvider, getSystemEntity, saveTo, saveTo, saveTo, saveTo

Methods inherited from interface com.storedobject.core.ContentType

getLink, getMimeType, isAudio, isHTML, isImage, isLink, isMedia, isPDF, isText, isVideo

Methods inherited from interface com.storedobject.common.Executable

act, run

Constructor Details

Excel

public Excel()

Constructor. This will create a blank Excel file and the content may be manipulated in the AbstractSpreadSheet.generateContent() method.

Excel

public Excel(OutputStream out)

Constructor.

Parameters:

out - Output is written to this stream.

Excel

public Excel(InputStream in)

Constructor.

Parameters:

in - Input stream containing an Excel file with some content.

Excel

public Excel(String databaseFileName)

Constructor.

Parameters:

databaseFileName - Database file name (FileData) containing Excel file with some content.

Excel

public Excel(FileData fileData)

Constructor.

Parameters:

fileData - Database file containing Excel file with some content.

Excel

public Excel(Id templateId)

Constructor

Parameters:

templateId - Id of the stream data containing Excel file with some content.

Excel

public Excel(Id templateId,
 OutputStream out)

Constructor

Parameters:

templateId - Id of the stream data containing Excel file with some content.

out - Output is written to this stream.

Excel

public Excel(StreamData streamData)

Constructor

Parameters:

streamData - Stream data containing Excel file with some content.

Excel

public Excel(StreamData streamData,
 OutputStream out)

Constructor

Parameters:

streamData - Stream data containing Excel file with some content.

out - Output is written to this stream.

Excel

public Excel(InputStream in,
 OutputStream out)

Constructor.

Parameters:

in - Input stream containing an Excel file with some content.

out - Output is written to this stream.

Method Details

createWorkbook

protected org.apache.poi.ss.usermodel.Workbook createWorkbook(InputStream in)
                                                       throws Exception

Specified by:

createWorkbook in class AbstractSpreadSheet

Throws:

Exception

getContentType

public String getContentType()

getFileExtension

public String getFileExtension()

recompute

public void recompute()

Re-evaluate all formula in the worksheet.

Specified by:

recompute in class AbstractSpreadSheet