Package io.jmix.gridexportflowui.exporter.excel

Class ExcelExporter

java.lang.Object

io.jmix.gridexportflowui.exporter.AbstractDataGridExporter<ExcelExporter>

io.jmix.gridexportflowui.exporter.excel.ExcelExporter

All Implemented Interfaces:

DataGridExporter

@Component("grdexp_ExcelExporter")
@Scope("prototype")
public class ExcelExporter
extends AbstractDataGridExporter<ExcelExporter>

Nested Class Summary

Nested classes/interfaces inherited from interface io.jmix.gridexportflowui.exporter.DataGridExporter

DataGridExporter.ColumnValueContext

Field Summary

Fields

Modifier and Type	Field	Description
protected AllRecordsExporter	allRecordsExporter
protected org.apache.poi.ss.usermodel.Font	boldFont
protected static final int	COL_WIDTH_MAGIC
protected org.apache.poi.ss.usermodel.CellStyle	dateFormatCellStyle
protected org.apache.poi.ss.usermodel.CellStyle	dateTimeFormatCellStyle
protected org.apache.poi.ss.usermodel.CellStyle	doubleFormatCellStyle
protected boolean	exportAggregation
protected Boolean	exportExpanded
protected GridExportProperties	gridExportProperties
protected org.apache.poi.ss.usermodel.CellStyle	integerFormatCellStyle
protected boolean	isRowNumberExceeded
static final int	MAX_ROW_COUNT
protected org.apache.poi.ss.usermodel.Sheet	sheet
protected ExcelAutoColumnSizer[]	sizers
protected org.apache.poi.ss.usermodel.Font	stdFont
protected org.apache.poi.ss.usermodel.CellStyle	timeFormatCellStyle
protected org.apache.poi.ss.usermodel.Workbook	wb

Fields inherited from class io.jmix.gridexportflowui.exporter.AbstractDataGridExporter

columnValueProviders, coreProperties, datatypeRegistry, fileName, flowuiProperties, messages, messageTools, metadataTools

Constructor Summary

Constructors

Constructor	Description
ExcelExporter(GridExportProperties gridExportProperties, AllRecordsExporter allRecordsExporter)

Method Summary

Modifier and Type	Method	Description
protected boolean	checkIsRowNumberExceed(int r)
protected void	createAutoColumnSizers(int count)
protected int	createDataGridHierarchicalRow(com.vaadin.flow.component.treegrid.TreeGrid<?> dataGrid, ContainerTreeDataGridItems<Object> treeDataGridItems, List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns, int startColumn, int rowNumber, Object item)
protected void	createDataGridRow(com.vaadin.flow.component.grid.Grid<?> dataGrid, List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns, int startColumn, int rowNumber, Object itemId)
protected void	createDataGridRowForEntityInstance(com.vaadin.flow.component.grid.Grid<?> dataGrid, List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns, int startColumn, int rowNumber, Object entityInstance, boolean addLevelPadding)
protected void	createFonts()
protected void	createFormats()
protected Function<Object,InstanceContainer<Object>>	createInstanceContainerProvider(com.vaadin.flow.component.grid.Grid<?> dataGrid, Object item)
protected String	createSpaceString(int level)
protected void	createWorkbookWithSheet()
protected void	disposeWorkBook()
void	exportDataGrid(Downloader downloader, com.vaadin.flow.component.grid.Grid<Object> dataGrid, ExportMode exportMode)	download dataGrid content via downloader
protected void	formatValueCell(org.apache.poi.ss.usermodel.Cell cell, Object cellValue, MetaPropertyPath metaPropertyPath, int sizersIndex, int notificationRequired, int level, Integer groupChildCount)
protected short	getBuiltinFormat(String format)
boolean	getExportAggregation()
Boolean	getExportExpanded()
String	getLabel()
protected String	getMessage(String id)
void	setExportAggregation(boolean exportAggregation)	Export table with aggregation
void	setExportExpanded(Boolean exportExpanded)	Export tree table with expanded rows
ExcelExporter	withExportAggregation(Boolean exportAggregation)	Export table with aggregation
ExcelExporter	withExportExpanded(Boolean exportExpanded)	Export tree table with expanded rows

Methods inherited from class io.jmix.gridexportflowui.exporter.AbstractDataGridExporter

addColumnValueProvider, formatValue, formatValue, getColumnValue, getColumnValueProvider, getFileName, getFileName, getMetaClassName, removeColumnValueProvider, setCoreProperties, setDatatypeRegistry, setFileName, setFlowuiProperties, setMessages, setMessageTools, setMetadataTools, withFileName

Methods inherited from class java.lang.Object

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

Field Details

COL_WIDTH_MAGIC

protected static final int COL_WIDTH_MAGIC

See Also:

• Constant Field Values

MAX_ROW_COUNT

public static final int MAX_ROW_COUNT

wb

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

boldFont

protected org.apache.poi.ss.usermodel.Font boldFont

stdFont

protected org.apache.poi.ss.usermodel.Font stdFont

sheet

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

timeFormatCellStyle

protected org.apache.poi.ss.usermodel.CellStyle timeFormatCellStyle

dateFormatCellStyle

protected org.apache.poi.ss.usermodel.CellStyle dateFormatCellStyle

dateTimeFormatCellStyle

protected org.apache.poi.ss.usermodel.CellStyle dateTimeFormatCellStyle

integerFormatCellStyle

protected org.apache.poi.ss.usermodel.CellStyle integerFormatCellStyle

doubleFormatCellStyle

protected org.apache.poi.ss.usermodel.CellStyle doubleFormatCellStyle

sizers

protected ExcelAutoColumnSizer[] sizers

exportAggregation

protected boolean exportAggregation

exportExpanded

protected Boolean exportExpanded

isRowNumberExceeded

protected boolean isRowNumberExceeded

gridExportProperties

protected GridExportProperties gridExportProperties

allRecordsExporter

protected AllRecordsExporter allRecordsExporter

Constructor Details

ExcelExporter

public ExcelExporter(GridExportProperties gridExportProperties,
 AllRecordsExporter allRecordsExporter)

Method Details

createWorkbookWithSheet

protected void createWorkbookWithSheet()

createFonts

protected void createFonts()

createAutoColumnSizers

protected void createAutoColumnSizers(int count)

exportDataGrid

public void exportDataGrid(Downloader downloader,
 com.vaadin.flow.component.grid.Grid<Object> dataGrid,
 ExportMode exportMode)

Description copied from interface: DataGridExporter

download dataGrid content via downloader

createDataGridHierarchicalRow

protected int createDataGridHierarchicalRow(com.vaadin.flow.component.treegrid.TreeGrid<?> dataGrid,
 ContainerTreeDataGridItems<Object> treeDataGridItems,
 List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns,
 int startColumn,
 int rowNumber,
 Object item)

createDataGridRow

protected void createDataGridRow(com.vaadin.flow.component.grid.Grid<?> dataGrid,
 List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns,
 int startColumn,
 int rowNumber,
 Object itemId)

createDataGridRowForEntityInstance

protected void createDataGridRowForEntityInstance(com.vaadin.flow.component.grid.Grid<?> dataGrid,
 List<com.vaadin.flow.component.grid.Grid.Column<Object>> columns,
 int startColumn,
 int rowNumber,
 Object entityInstance,
 boolean addLevelPadding)

createInstanceContainerProvider

protected Function<Object,InstanceContainer<Object>> createInstanceContainerProvider(com.vaadin.flow.component.grid.Grid<?> dataGrid,
 Object item)

Overrides:

createInstanceContainerProvider in class AbstractDataGridExporter<ExcelExporter>

createFormats

protected void createFormats()

getBuiltinFormat

protected short getBuiltinFormat(String format)

getMessage

protected String getMessage(String id)

createSpaceString

protected String createSpaceString(int level)

formatValueCell

protected void formatValueCell(org.apache.poi.ss.usermodel.Cell cell,
 @Nullable
 Object cellValue,
 @Nullable
 MetaPropertyPath metaPropertyPath,
 int sizersIndex,
 int notificationRequired,
 int level,
 @Nullable
 Integer groupChildCount)

checkIsRowNumberExceed

protected boolean checkIsRowNumberExceed(int r)

getExportAggregation

public boolean getExportAggregation()

Returns:

export aggregation

setExportAggregation

public void setExportAggregation(boolean exportAggregation)

Export table with aggregation

Parameters:

exportAggregation - set to true to export table with aggregation

withExportAggregation

public ExcelExporter withExportAggregation(Boolean exportAggregation)

Export table with aggregation

Parameters:

exportAggregation - set to true to export table with aggregation

Returns:

exporter instance

getExportExpanded

public Boolean getExportExpanded()

Returns:

tree table export expanded

setExportExpanded

public void setExportExpanded(Boolean exportExpanded)

Export tree table with expanded rows

Parameters:

exportExpanded - set to true to export collapsed items in expanded view

withExportExpanded

public ExcelExporter withExportExpanded(Boolean exportExpanded)

Export tree table with expanded rows

Parameters:

exportExpanded - set to true to export collapsed items in expanded view

Returns:

exporter instance

getLabel

public String getLabel()

Returns:

exporter label

disposeWorkBook

protected void disposeWorkBook()