org.eclipse.nebula.widgets.nattable.extension.poi

Class PoiExcelExporter

java.lang.Object

org.eclipse.nebula.widgets.nattable.extension.poi.PoiExcelExporter

All Implemented Interfaces:

IExporter, ILayerExporter

Direct Known Subclasses:

HSSFExcelExporter

public abstract class PoiExcelExporter
extends Object
implements ILayerExporter

Field Summary

Fields

Modifier and Type	Field and Description
protected int	currentRow
protected org.apache.poi.ss.usermodel.Drawing	drawing
protected boolean	exportOnSameSheet
protected FormulaParser	formulaParser
protected org.apache.poi.ss.usermodel.CreationHelper	helper
protected NumberFormat	nf
protected int	sheetNumber
protected org.apache.poi.ss.usermodel.Row	xlRow
protected org.apache.poi.ss.usermodel.Sheet	xlSheet
protected org.apache.poi.ss.usermodel.Workbook	xlWorkbook

Constructor Summary

Constructors

Constructor and Description
PoiExcelExporter(IOutputStreamProvider outputStreamProvider)

Method Summary

Modifier and Type	Method and Description
protected abstract org.apache.poi.ss.usermodel.Workbook	createWorkbook()
void	exportBegin(OutputStream outputStream) Need to be called only once at the beginning of an export operation.
void	exportCell(OutputStream outputStream, Object exportDisplayValue, ILayerCell cell, IConfigRegistry configRegistry) Exports one cell.
void	exportEnd(OutputStream outputStream) Need to be called only once at the end of an export operation.
protected void	exportImage(InputStream is, org.apache.poi.ss.usermodel.Cell xlCell) Adds a picture to the workbook at the given cell position.
void	exportLayerBegin(OutputStream outputStream, String layerName) Starts the export operation of one ILayer.
void	exportLayerEnd(OutputStream outputStream, String layerName) Ends the export operation of one ILayer.
void	exportRowBegin(OutputStream outputStream, int rowPosition) Starts the export operation of one row.
void	exportRowEnd(OutputStream outputStream, int rowPosition) Ends the export operation of one row.
protected String	getDataFormatString(ILayerCell cell, IConfigRegistry configRegistry)
OutputStream	getOutputStream(org.eclipse.swt.widgets.Shell shell) Get the OutputStream to which the export should be written to.
Object	getResult()
void	setApplyBackgroundColor(boolean applyBackgroundColor)
void	setApplyCellBorders(boolean apply) Configure this exporter whether it should render cell borders on all cells.
void	setApplyCellDimensions(boolean apply) Configure this exporter whether it should apply the cell dimensions to the same size configuration the NatTable shows.
void	setApplyColumnWidths(boolean apply) Configure this exporter whether it should apply the column widths to the same size configuration the NatTable shows.
void	setApplyRowHeights(boolean apply) Configure this exporter whether it should apply the row heights to the same size configuration the NatTable shows.
void	setApplyTextWrapping(boolean inspectTextWrap) Configure this exporter whether it should check for text wrapping configuration in NatTable and apply the corresponding style attribute in the export, or not.
void	setApplyVerticalTextConfiguration(boolean inspectVertical) Configure this exporter whether it should check for vertical text configuration in NatTable and apply the corresponding rotation style attribute in the export, or not.
void	setExportOnSameSheet(boolean sameSheet)
protected abstract void	setFillForegroundColor(org.apache.poi.ss.usermodel.CellStyle xlCellStyle, org.eclipse.swt.graphics.Color swtColor)
protected abstract void	setFontColor(org.apache.poi.ss.usermodel.Font xlFont, org.eclipse.swt.graphics.Color swtColor)
void	setFormulaParser(FormulaParser formulaParser) Configure the FormulaParser that should be used to determine whether formulas should be exported or not.
void	setNumberFormat(NumberFormat nf)
void	setSheetname(String sheetname)

Methods inherited from class java.lang.Object

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

Field Detail

xlWorkbook

protected org.apache.poi.ss.usermodel.Workbook xlWorkbook

sheetNumber

protected int sheetNumber

xlSheet

protected org.apache.poi.ss.usermodel.Sheet xlSheet

xlRow

protected org.apache.poi.ss.usermodel.Row xlRow

formulaParser

protected FormulaParser formulaParser

nf

protected NumberFormat nf

helper

protected org.apache.poi.ss.usermodel.CreationHelper helper

drawing

protected org.apache.poi.ss.usermodel.Drawing drawing

exportOnSameSheet

protected boolean exportOnSameSheet

currentRow

protected int currentRow

Constructor Detail

PoiExcelExporter

public PoiExcelExporter(IOutputStreamProvider outputStreamProvider)

Method Detail

getOutputStream

public OutputStream getOutputStream(org.eclipse.swt.widgets.Shell shell)

Description copied from interface: IExporter

Get the OutputStream to which the export should be written to.

Specified by:

getOutputStream in interface IExporter

Parameters:

shell - The Shell to which the ILayer to export is connected to. Necessary to support user interactions via dialogs on configuring the output location.

Returns:

The OutputStream to write the export to.

exportBegin

public void exportBegin(OutputStream outputStream)
                 throws IOException

Description copied from interface: ILayerExporter

Need to be called only once at the beginning of an export operation. It is used to initialize the export operation like e.g. letting a user specify the export location via file selection dialog or creating a workbook.

Note: Also on exporting multiple NatTable instances as part of a single export operation, this method should only be called once before any layers are exported.

Specified by:

exportBegin in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

Throws:

IOException - If the beginning of an export already performs I/O operations that fail.

exportEnd

public void exportEnd(OutputStream outputStream)
               throws IOException

Description copied from interface: ILayerExporter

Need to be called only once at the end of an export operation. It is used to cleanup resources after the export operation, like e.g. closing opened streams.

Note: Also on exporting multiple NatTable instances as part of a single export operation, this method should only be called once after all layers are exported.

Specified by:

exportEnd in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

Throws:

IOException - If finishing the export operation fails on an I/O operation.

exportLayerBegin

public void exportLayerBegin(OutputStream outputStream,
                             String layerName)
                      throws IOException

Description copied from interface: ILayerExporter

Starts the export operation of one ILayer. Is used for example to initialize a sheet in a workbook or open the root tags in a XML format.

On exporting multiple NatTable instances, this method needs to be called once for every instance.

Specified by:

exportLayerBegin in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

layerName - The name that should be used as sheet name.

Throws:

IOException - If an error occurred during writing the export.

exportLayerEnd

public void exportLayerEnd(OutputStream outputStream,
                           String layerName)
                    throws IOException

Description copied from interface: ILayerExporter

Ends the export operation of one ILayer. Is used for example to finish the export, like closing tags in a XML format.

On exporting multiple NatTable instances, this method needs to be called once for every instance.

Specified by:

exportLayerEnd in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

layerName - The name that is used as sheet name. Usually not necessary, but in case there is caching involved in a custom ILayerExporter implementation, this can be used to retrieve the ILayer instance again.

Throws:

IOException - If an error occurred during writing the export.

exportRowBegin

public void exportRowBegin(OutputStream outputStream,
                           int rowPosition)
                    throws IOException

Description copied from interface: ILayerExporter

Starts the export operation of one row. Is used for example to initialize a row in a sheet or open some tags in a XML format.

Specified by:

exportRowBegin in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

rowPosition - The position of the row to export.

Throws:

IOException - If an error occurred during writing the export.

exportRowEnd

public void exportRowEnd(OutputStream outputStream,
                         int rowPosition)
                  throws IOException

Description copied from interface: ILayerExporter

Ends the export operation of one row.

Specified by:

exportRowEnd in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

rowPosition - The position of the row that was exported. Usually not necessary, but in case there is caching involved in a custom ILayerExporter implementation, this can be used to retrieve the row again.

Throws:

IOException - If an error occurred during writing the export.

exportCell

public void exportCell(OutputStream outputStream,
                       Object exportDisplayValue,
                       ILayerCell cell,
                       IConfigRegistry configRegistry)
                throws IOException

Description copied from interface: ILayerExporter

Exports one cell.

Specified by:

exportCell in interface ILayerExporter

Parameters:

outputStream - The OutputStream to write the export to.

exportDisplayValue - The value that will be written to the export file. This value is determined by using the data value of the ILayerCell and the registered IExportFormatter within the NatExporter.

cell - The ILayerCell that is currently exported.

configRegistry - The ConfigRegistry to retrieve the registered style information of the cell that is currently exported.

Throws:

IOException - If an error occurred during writing the export.

getDataFormatString

protected String getDataFormatString(ILayerCell cell,
                                     IConfigRegistry configRegistry)

Parameters:

cell - The cell for which the date format needs to be determined.

configRegistry - The ConfigRegistry needed to retrieve the configuration.

Returns:

The date format that should be used to format Date or Calendar values in the export.

setApplyBackgroundColor

public void setApplyBackgroundColor(boolean applyBackgroundColor)

Parameters:

applyBackgroundColor - true to apply the background color set in the NatTable to the exported Excel. This also includes white background and header background color. false if the background color should not be set on export.

setApplyVerticalTextConfiguration

public void setApplyVerticalTextConfiguration(boolean inspectVertical)

Configure this exporter whether it should check for vertical text configuration in NatTable and apply the corresponding rotation style attribute in the export, or not.

Note: As showing text vertically in NatTable is not a style information but a configured via painter implementation, the check whether text is showed vertically needs to be done via reflection. Therefore setting this value to true could cause performance issues. As vertical text is not the default case and the effect on performance might be negative, the default value for this configuration is false. If vertical text (e.g. column headers) should also be exported vertically, you need to set this value to true.

Parameters:

inspectVertical - true to configure this exporter to check for vertical text configuration and apply the rotation style for the export, false to always use the regular text direction, regardless of vertical rendered text in NatTable.

setApplyTextWrapping

public void setApplyTextWrapping(boolean inspectTextWrap)

Configure this exporter whether it should check for text wrapping configuration in NatTable and apply the corresponding style attribute in the export, or not.

Note: As showing text wrapping in NatTable is not a style information but a configured via painter implementation, the check whether text is wrapped needs to be done via reflection. Therefore setting this value to true could cause performance issues. As wrapped text is not the default case and the effect on performance might be negative, the default value for this configuration is false. If wrapped text (e.g. column headers) should also be exported wrapped, you need to set this value to true.

Parameters:

inspectTextWrap - true to configure this exporter to check for text wrapping configuration, false to never apply text wrapping to the export.

Since:

1.5

setApplyCellDimensions

public void setApplyCellDimensions(boolean apply)

Configure this exporter whether it should apply the cell dimensions to the same size configuration the NatTable shows.

Parameters:

apply - true to configure this exporter to apply the cell dimensions based on the NatTable cell dimensions, false if the Excel default cell dimensions should be used.

Since:

1.5

setApplyColumnWidths

public void setApplyColumnWidths(boolean apply)

Configure this exporter whether it should apply the column widths to the same size configuration the NatTable shows.

Parameters:

apply - true to configure this exporter to apply the column widths based on the NatTable cell dimensions, false if the Excel default cell dimensions should be used.

Since:

1.5

setApplyRowHeights

public void setApplyRowHeights(boolean apply)

Configure this exporter whether it should apply the row heights to the same size configuration the NatTable shows.

Parameters:

apply - true to configure this exporter to apply the row heights based on the NatTable cell dimensions, false if the Excel default cell dimensions should be used.

Since:

1.5

setApplyCellBorders

public void setApplyCellBorders(boolean apply)

Configure this exporter whether it should render cell borders on all cells. This should typically be enabled if background colors should be applied to make the cell borders visible.

Parameters:

apply - true to configure this exporter to render cell borders, false if not.

Since:

1.5

createWorkbook

protected abstract org.apache.poi.ss.usermodel.Workbook createWorkbook()

setFillForegroundColor

protected abstract void setFillForegroundColor(org.apache.poi.ss.usermodel.CellStyle xlCellStyle,
                                               org.eclipse.swt.graphics.Color swtColor)

setFontColor

protected abstract void setFontColor(org.apache.poi.ss.usermodel.Font xlFont,
                                     org.eclipse.swt.graphics.Color swtColor)

getResult

public Object getResult()

Specified by:

getResult in interface IExporter

Returns:

The result that is produced by this ITableExporter. Usually the file that is created or written by this exporter.

setSheetname

public void setSheetname(String sheetname)

Parameters:

sheetname - The name that should be set as sheet name in the resulting Excel file. Setting this value to null will result in a sheet name following the pattern Sheet + <sheet number>

setFormulaParser

public void setFormulaParser(FormulaParser formulaParser)

Configure the FormulaParser that should be used to determine whether formulas should be exported or not. If null is set, formulas and cell values of type string will be simply exported as string. If a valid FormulaParser is set, cell values will get inspected so that number values are converted to numbers and formulas will be exported as formulas.

Parameters:

formulaParser - The FormulaParser that should be used to determine whether cell values should be interpreted as formulas or null to disable formula export handling.

Since:

1.4

setNumberFormat

public void setNumberFormat(NumberFormat nf)

Parameters:

nf - The NumberFormat that should be used to format numeric values.

exportImage

protected void exportImage(InputStream is,
                           org.apache.poi.ss.usermodel.Cell xlCell)

Adds a picture to the workbook at the given cell position.

Parameters:

is - The InputStream to access the picture. This will be automatically closed after reading.

xlCell - The Cell to position the image to.

Since:

1.5

setExportOnSameSheet

public void setExportOnSameSheet(boolean sameSheet)

Parameters:

sameSheet - true if multiple NatTable instances should be exported on the same sheet, false if every instance should be exported on separate sheets. Default is false.

Since:

1.5