Package org.adempiere.print.export

Class PrintDataXLSXExporter

java.lang.Object

org.adempiere.impexp.AbstractXLSXExporter

org.adempiere.print.export.PrintDataXLSXExporter

public class PrintDataXLSXExporter
extends AbstractXLSXExporter

Export PrintData to Excel (XLSX) file

Author:

Deepak Pansheriya

Field Summary

Fields inherited from class org.adempiere.impexp.AbstractXLSXExporter

colSuppressRepeats, log, m_lang, m_workbook

Constructor Summary

Constructors

Constructor	Description
PrintDataXLSXExporter(PrintData printData, MPrintFormat printFormat)
PrintDataXLSXExporter(PrintData printData, MPrintFormat printFormat, Boolean[] colSuppressRepeats)
PrintDataXLSXExporter(PrintData printData, MPrintFormat printFormat, Map<MPrintFormatItem,PrintData> childPrintFormatDetails, Boolean[] colSuppressRepeats, MQuery query)

Method Summary

Modifier and Type	Method	Description
protected void	createParameter(org.apache.poi.ss.usermodel.Sheet sheet)	Create parameter
protected void	export(OutputStream out)	Export to given stream
protected void	formatPage(org.apache.poi.ss.usermodel.Sheet sheet)	Format sheet
protected String	getCellFormat(int row, int col)
int	getColumnCount()	Get Columns Count
protected int	getCurrentRow()
int	getDisplayType(int row, int col)	Get cell display type (see DisplayType)
protected org.apache.poi.ss.usermodel.Cell	getFormCell(org.apache.poi.ss.usermodel.Row row, int colnum)	get cell for column. use for form layout
protected org.apache.poi.ss.usermodel.Row	getFormRow(org.apache.poi.ss.usermodel.Sheet sheet, int colnum)	get row for column. use for form layout
String	getHeaderName(int col)	Get column header name
int	getRowCount()	Get Rows Count
Object	getValueAt(int row, int col)	Get cell value
boolean	isColumnPrinted(int col)	Check if column is printed (displayed)
boolean	isDisplayed(int row, int col)	Check if there is a display logic
protected boolean	isForm()
boolean	isFunctionRow()	Is the current Row a Function Row
boolean	isPageBreak(int row, int col)	Check if there is a page break on given cell
protected boolean	isSetFormRowPosition(int col)
protected boolean	isSuppressNull(int col)
protected boolean	isVisible(int row, int col)
protected void	setCurrentRow(int row)	Set current row

Methods inherited from class org.adempiere.impexp.AbstractXLSXExporter

createHeaderFooter, export, export, exportToWorkbook, getCtx, getLanguage, getNoOfParameter, isCurrentRowOnly, setCurrentRowOnly, setFreezePane, setNoOfParameter

Methods inherited from class java.lang.Object

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

Constructor Details

PrintDataXLSXExporter

public PrintDataXLSXExporter(PrintData printData,
 MPrintFormat printFormat)

Parameters:

printData -

printFormat -

PrintDataXLSXExporter

public PrintDataXLSXExporter(PrintData printData,
 MPrintFormat printFormat,
 Boolean[] colSuppressRepeats)

Parameters:

printData -

printFormat -

colSuppressRepeats -

PrintDataXLSXExporter

public PrintDataXLSXExporter(PrintData printData,
 MPrintFormat printFormat,
 Map<MPrintFormatItem,PrintData> childPrintFormatDetails,
 Boolean[] colSuppressRepeats,
 MQuery query)

Parameters:

printData -

printFormat -

childPrintFormatDetails -

colSuppressRepeats -

query -

Method Details

getColumnCount

public int getColumnCount()

Description copied from class: AbstractXLSXExporter

Get Columns Count

Specified by:

getColumnCount in class AbstractXLSXExporter

Returns:

number of columns

getDisplayType

public int getDisplayType(int row,
 int col)

Description copied from class: AbstractXLSXExporter

Get cell display type (see DisplayType)

Specified by:

getDisplayType in class AbstractXLSXExporter

Parameters:

row - row index

col - column index

Returns:

display type

getValueAt

public Object getValueAt(int row,
 int col)

Description copied from class: AbstractXLSXExporter

Get cell value

Specified by:

getValueAt in class AbstractXLSXExporter

Parameters:

row - row index

col - column index

Returns:

cell value

getHeaderName

public String getHeaderName(int col)

Description copied from class: AbstractXLSXExporter

Get column header name

Specified by:

getHeaderName in class AbstractXLSXExporter

Parameters:

col - column index

Returns:

header name

getRowCount

public int getRowCount()

Description copied from class: AbstractXLSXExporter

Get Rows Count

Specified by:

getRowCount in class AbstractXLSXExporter

Returns:

number of rows

isColumnPrinted

public boolean isColumnPrinted(int col)

Description copied from class: AbstractXLSXExporter

Check if column is printed (displayed)

Specified by:

isColumnPrinted in class AbstractXLSXExporter

Parameters:

col - column index

Returns:

true if is visible

isPageBreak

public boolean isPageBreak(int row,
 int col)

Description copied from class: AbstractXLSXExporter

Check if there is a page break on given cell

Specified by:

isPageBreak in class AbstractXLSXExporter

Parameters:

row - row index

col - column index

Returns:

true if there is a page break

setCurrentRow

protected void setCurrentRow(int row)

Description copied from class: AbstractXLSXExporter

Set current row

Specified by:

setCurrentRow in class AbstractXLSXExporter

Parameters:

row - row index

getCurrentRow

protected int getCurrentRow()

Specified by:

getCurrentRow in class AbstractXLSXExporter

Returns:

current row index

isFunctionRow

public boolean isFunctionRow()

Description copied from class: AbstractXLSXExporter

Is the current Row a Function Row

Specified by:

isFunctionRow in class AbstractXLSXExporter

Returns:

true if function row

formatPage

protected void formatPage(org.apache.poi.ss.usermodel.Sheet sheet)

Description copied from class: AbstractXLSXExporter

Format sheet

Overrides:

formatPage in class AbstractXLSXExporter

isDisplayed

public boolean isDisplayed(int row,
 int col)

Description copied from class: AbstractXLSXExporter

Check if there is a display logic

Specified by:

isDisplayed in class AbstractXLSXExporter

Parameters:

row - row index

col - column index

Returns:

true if there is no logic or evaluate logic specified in print item

getCellFormat

protected String getCellFormat(int row,
 int col)

Overrides:

getCellFormat in class AbstractXLSXExporter

Returns:

Excel format pattern for cell

export

protected void export(OutputStream out)
               throws Exception

Description copied from class: AbstractXLSXExporter

Export to given stream

Overrides:

export in class AbstractXLSXExporter

Throws:

Exception

createParameter

protected void createParameter(org.apache.poi.ss.usermodel.Sheet sheet)

Description copied from class: AbstractXLSXExporter

Create parameter

Overrides:

createParameter in class AbstractXLSXExporter

isForm

protected boolean isForm()

Overrides:

isForm in class AbstractXLSXExporter

Returns:

true if it is form layout

getFormCell

protected org.apache.poi.ss.usermodel.Cell getFormCell(org.apache.poi.ss.usermodel.Row row,
 int colnum)

Description copied from class: AbstractXLSXExporter

get cell for column. use for form layout

Overrides:

getFormCell in class AbstractXLSXExporter

Returns:

cell for column

getFormRow

protected org.apache.poi.ss.usermodel.Row getFormRow(org.apache.poi.ss.usermodel.Sheet sheet,
 int colnum)

Description copied from class: AbstractXLSXExporter

get row for column. use for form layout

Overrides:

getFormRow in class AbstractXLSXExporter

Returns:

row for column

isSetFormRowPosition

protected boolean isSetFormRowPosition(int col)

Overrides:

isSetFormRowPosition in class AbstractXLSXExporter

Returns:

true if column is use to set new row position

isSuppressNull

protected boolean isSuppressNull(int col)

Overrides:

isSuppressNull in class AbstractXLSXExporter

Returns:

true if column should be hidden when it is null

isVisible

protected boolean isVisible(int row,
 int col)

Overrides:

isVisible in class AbstractXLSXExporter

Returns:

true if cell is visible