io.jmix.pivottable.component.impl

Class PivotDataExcelHelper

java.lang.Object

io.jmix.pivottable.component.impl.PivotDataExcelHelper

public class PivotDataExcelHelper
extends java.lang.Object

Helps to convert PivotDataRow to list with separated cells and provides methods for merging cells.

Field Summary

Fields

Modifier and Type	Field and Description
protected java.util.List<java.lang.String>	cellIdsToMerged
protected java.util.List<PivotDataSeparatedCell>	cellsToMerged
protected PivotData	pivotData
protected java.util.List<java.util.List<PivotDataSeparatedCell>>	rows

Constructor Summary

Constructors

Constructor and Description
PivotDataExcelHelper(PivotData pivotData)

Method Summary

Modifier and Type	Method and Description
protected boolean	addAboveCell(PivotDataSeparatedCell aboveCell, int indexRow)
protected PivotDataSeparatedCell	convertPivotCellToSeparatedCell(PivotDataCell pivotDataCell)
protected int	createAndAddSeparatedCells(PivotDataSeparatedCell separatedCell, java.util.List<PivotDataSeparatedCell> cellsRow)
protected java.util.List<PivotDataSeparatedCell>	createRow(PivotDataRow currentRow, java.util.List<PivotDataSeparatedCell> prevRow)
java.util.List<java.lang.String>	getCellIdsToMerged()
java.util.List<org.apache.poi.ss.util.CellRangeAddress>	getCellRangeAddresses()
int	getFirstColById(java.lang.String id)
int	getFirstRowById(java.lang.String id)
int	getLastColById(java.lang.String id)
int	getLastRowById(java.lang.String id)
int	getOriginColumnsNumber()
java.util.List<java.util.List<PivotDataSeparatedCell>>	getRows()
protected void	initRows()

Methods inherited from class java.lang.Object

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

Field Detail

pivotData

protected PivotData pivotData

cellsToMerged

protected java.util.List<PivotDataSeparatedCell> cellsToMerged

cellIdsToMerged

protected java.util.List<java.lang.String> cellIdsToMerged

rows

protected java.util.List<java.util.List<PivotDataSeparatedCell>> rows

Constructor Detail

PivotDataExcelHelper

public PivotDataExcelHelper(PivotData pivotData)

Method Detail

initRows

protected void initRows()

getRows

public java.util.List<java.util.List<PivotDataSeparatedCell>> getRows()

Returns:

pivot table data with separated cells (all merged cells were separated and each separated cell has common value and id)

getOriginColumnsNumber

public int getOriginColumnsNumber()

Returns:

number of exactly excel columns and -1 if there is no columns

getCellIdsToMerged

public java.util.List<java.lang.String> getCellIdsToMerged()

Returns:

list with unique cells id which should be merged

getFirstRowById

public int getFirstRowById(java.lang.String id)

Parameters:

id - PivotDataSeparatedCell id that should be merged

Returns:

first row index of all cells that should be merged by common id

getLastRowById

public int getLastRowById(java.lang.String id)

Parameters:

id - PivotDataSeparatedCell id that should be merged

Returns:

last row index of all cells that should be merged by common id

getFirstColById

public int getFirstColById(java.lang.String id)

Parameters:

id - PivotDataSeparatedCell id that should be merged

Returns:

first col index of all cells that should be merged by common id

getLastColById

public int getLastColById(java.lang.String id)

Parameters:

id - PivotDataSeparatedCell id that should be merged

Returns:

last col index of all cells that should be merged by common id

getCellRangeAddresses

public java.util.List<org.apache.poi.ss.util.CellRangeAddress> getCellRangeAddresses()

Returns:

a collection of cell range addresses that should be merged in the HSSFSheet

createRow

protected java.util.List<PivotDataSeparatedCell> createRow(PivotDataRow currentRow,
                                                           java.util.List<PivotDataSeparatedCell> prevRow)

addAboveCell

protected boolean addAboveCell(PivotDataSeparatedCell aboveCell,
                               int indexRow)

createAndAddSeparatedCells

protected int createAndAddSeparatedCells(PivotDataSeparatedCell separatedCell,
                                         java.util.List<PivotDataSeparatedCell> cellsRow)

convertPivotCellToSeparatedCell

protected PivotDataSeparatedCell convertPivotCellToSeparatedCell(PivotDataCell pivotDataCell)