io.jmix.pivottable.component.impl

Class PivotExcelExporter

java.lang.Object

io.jmix.pivottable.component.impl.PivotExcelExporter

@Component(value="ui_PivotExcelExporter")
 @Scope(value="prototype")
public class PivotExcelExporter
extends java.lang.Object

Exports PivotData to XLS file.

Field Summary

Fields

Modifier and Type	Field and Description
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	boldCellDateStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	boldCellDateTimeStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	boldCellTimeStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	cellDateStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	cellDateTimeStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	cellLabelBoldStyle
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	cellTimeStyle
protected static int	COLUMN_WIDTH_MULTIPLIER CAUTION Magic number! This multiplier is used for calculating column width.
protected io.jmix.core.CoreProperties	coreProperties
protected java.lang.String	dateParseFormat
protected java.lang.String	dateTimeParseFormat
static java.lang.String	DEFAULT_FILE_NAME
protected Downloader	downloader
protected io.jmix.core.metamodel.model.MetaClass	entityMetaClass
protected java.lang.String	fileName
static int	MAX_ROW_INDEX
protected io.jmix.core.Messages	messages
protected io.jmix.core.MessageTools	messageTools
protected Notifications	notifications
protected org.apache.poi.hssf.usermodel.HSSFSheet	sheet
protected org.apache.poi.hssf.usermodel.HSSFFont	stdFont
protected java.lang.String	timeParseFormat
protected UiProperties	uiProperties
protected org.apache.poi.hssf.usermodel.HSSFWorkbook	wb

Constructor Summary

Constructors

Constructor and Description
PivotExcelExporter()
PivotExcelExporter(PivotTable pivotTable)

Method Summary

Modifier and Type	Method and Description
protected void	createCellsStyle()
protected void	createRows(PivotData pivotData)
protected void	createWorkbookWithSheet()
protected void	export(Downloader downloader)
void	exportPivotTable(PivotData pivotData, java.lang.String fileName) Export to Xls.
void	exportPivotTable(PivotData pivotData, java.lang.String fileName, Downloader downloader) Export to Xls.
java.lang.String	getDateParseFormat()
java.lang.String	getDateTimeParseFormat()
java.lang.String	getTimeParseFormat()
void	init(PivotTable pivotTable)
protected void	initDateTimeCell(org.apache.poi.hssf.usermodel.HSSFCell hssfCell, PivotDataSeparatedCell cell, java.text.SimpleDateFormat formatter, org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle, org.apache.poi.hssf.usermodel.HSSFCellStyle boldCellStyle)
protected void	initNotifications(PivotTable pivotTable)
protected boolean	isPivotDataEmpty(PivotData pivotData)
boolean	isXlsMaxRowNumberExceeded(PivotData pivotData)
void	setDateParseFormat(java.lang.String dateParseFormat) Sets date format that will be used to finding dateTime value and exporting it to excel with date type.
void	setDateTimeParseFormat(java.lang.String dateTimeParseFormat) Sets dateTime format that will be used to finding dateTime value and exporting it to excel with dateTime type.
void	setDownloader(Downloader downloader)
void	setMessages(io.jmix.core.Messages messages)
void	setTimeParseFormat(java.lang.String timeParseFormat) Sets date format that will be used to finding dateTime value and exporting it to excel with date type.
protected void	showNoDataWarning()
protected void	showWarnNotification()
protected void	updateColumnSize(ExcelAutoColumnSizer[] sizers, PivotDataSeparatedCell cell)

Methods inherited from class java.lang.Object

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

Field Detail

MAX_ROW_INDEX

public static final int MAX_ROW_INDEX

See Also:

Constant Field Values

COLUMN_WIDTH_MULTIPLIER

protected static final int COLUMN_WIDTH_MULTIPLIER

CAUTION Magic number! This multiplier is used for calculating column width. Without this multiplier all columns in the file will be collapsed.

See Also:

Constant Field Values

DEFAULT_FILE_NAME

public static final java.lang.String DEFAULT_FILE_NAME

See Also:

Constant Field Values

wb

protected org.apache.poi.hssf.usermodel.HSSFWorkbook wb

sheet

protected org.apache.poi.hssf.usermodel.HSSFSheet sheet

stdFont

protected org.apache.poi.hssf.usermodel.HSSFFont stdFont

cellLabelBoldStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle cellLabelBoldStyle

cellDateTimeStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle cellDateTimeStyle

boldCellDateTimeStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle boldCellDateTimeStyle

cellDateStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle cellDateStyle

boldCellDateStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle boldCellDateStyle

cellTimeStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle cellTimeStyle

boldCellTimeStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle boldCellTimeStyle

fileName

protected java.lang.String fileName

entityMetaClass

protected io.jmix.core.metamodel.model.MetaClass entityMetaClass

messages

protected io.jmix.core.Messages messages

downloader

protected Downloader downloader

dateTimeParseFormat

protected java.lang.String dateTimeParseFormat

dateParseFormat

protected java.lang.String dateParseFormat

timeParseFormat

protected java.lang.String timeParseFormat

notifications

protected Notifications notifications

coreProperties

@Autowired
protected io.jmix.core.CoreProperties coreProperties

uiProperties

@Autowired
protected UiProperties uiProperties

messageTools

@Autowired
protected io.jmix.core.MessageTools messageTools

Constructor Detail

PivotExcelExporter

public PivotExcelExporter(PivotTable pivotTable)

PivotExcelExporter

public PivotExcelExporter()

Method Detail

init

public void init(PivotTable pivotTable)

setMessages

@Autowired
public void setMessages(io.jmix.core.Messages messages)

setDownloader

@Autowired
public void setDownloader(Downloader downloader)

initNotifications

protected void initNotifications(PivotTable pivotTable)

exportPivotTable

public void exportPivotTable(PivotData pivotData,
                             java.lang.String fileName)

Export to Xls.

Parameters:

pivotData - pivot with aggregated data

fileName - file name

exportPivotTable

public void exportPivotTable(PivotData pivotData,
                             java.lang.String fileName,
                             Downloader downloader)

Export to Xls.

Parameters:

pivotData - pivot with aggregated data

fileName - file name

downloader - ExportDisplay implementation

createRows

protected void createRows(PivotData pivotData)

updateColumnSize

protected void updateColumnSize(ExcelAutoColumnSizer[] sizers,
                                PivotDataSeparatedCell cell)

initDateTimeCell

protected void initDateTimeCell(org.apache.poi.hssf.usermodel.HSSFCell hssfCell,
                                PivotDataSeparatedCell cell,
                                java.text.SimpleDateFormat formatter,
                                org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle,
                                org.apache.poi.hssf.usermodel.HSSFCellStyle boldCellStyle)

createWorkbookWithSheet

protected void createWorkbookWithSheet()

createCellsStyle

protected void createCellsStyle()

showWarnNotification

protected void showWarnNotification()

export

protected void export(Downloader downloader)

showNoDataWarning

protected void showNoDataWarning()

isPivotDataEmpty

protected boolean isPivotDataEmpty(PivotData pivotData)

isXlsMaxRowNumberExceeded

public boolean isXlsMaxRowNumberExceeded(PivotData pivotData)

Parameters:

pivotData - pivot with aggregated data

Returns:

true if exported table contains more than 65536 records

getDateTimeParseFormat

@Nullable
public java.lang.String getDateTimeParseFormat()

Returns:

dateTime format or null

setDateTimeParseFormat

public void setDateTimeParseFormat(java.lang.String dateTimeParseFormat)

Sets dateTime format that will be used to finding dateTime value and exporting it to excel with dateTime type.

Parameters:

dateTimeParseFormat - dateTime format (e.g. dd/MM/yyyy HH:mm)

getDateParseFormat

@Nullable
public java.lang.String getDateParseFormat()

Returns:

date format or null

setDateParseFormat

public void setDateParseFormat(java.lang.String dateParseFormat)

Sets date format that will be used to finding dateTime value and exporting it to excel with date type. If there is no format set, date properties will be recognized as text value.

Parameters:

dateParseFormat - date format (e.g. dd/MM/yyyy)

getTimeParseFormat

@Nullable
public java.lang.String getTimeParseFormat()

Returns:

time format or null

setTimeParseFormat

public void setTimeParseFormat(java.lang.String timeParseFormat)

Sets date format that will be used to finding dateTime value and exporting it to excel with date type. If there is no format set, time properties will be recognized as text value.

Parameters:

timeParseFormat - time format (e.g. HH:mm)