Package org.adempiere.impexp

Class ArrayExcelExporter

java.lang.Object

org.adempiere.impexp.AbstractXLSXExporter

org.adempiere.impexp.ArrayExcelExporter

public class ArrayExcelExporter
extends AbstractXLSXExporter

Export to excel format (xlsx) from ArrayList of data

Author:

Teo Sarca, SC ARHIPAC SERVICE SRL

Field Summary

Fields inherited from class org.adempiere.impexp.AbstractXLSXExporter

colSuppressRepeats, log, m_lang, m_workbook

Constructor Summary

Constructors

Constructor	Description
ArrayExcelExporter(Properties ctx, ArrayList<ArrayList<Object>> data)

Method Summary

Modifier and Type	Method	Description
int	getColumnCount()	Get Columns Count
Properties	getCtx()
protected int	getCurrentRow()
int	getDisplayType(int row, int col)	Get cell display type (see DisplayType)
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
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 void	setCurrentRow(int row)	Set current row

Methods inherited from class org.adempiere.impexp.AbstractXLSXExporter

createHeaderFooter, createParameter, export, export, export, exportToWorkbook, formatPage, getCellFormat, getFormCell, getFormRow, getLanguage, getNoOfParameter, isCurrentRowOnly, isForm, isSetFormRowPosition, isSuppressNull, isVisible, setCurrentRowOnly, setFreezePane, setNoOfParameter

Methods inherited from class java.lang.Object

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

Constructor Details

ArrayExcelExporter

public ArrayExcelExporter(Properties ctx,
 ArrayList<ArrayList<Object>> data)

Parameters:

ctx -

data -

Method Details

getCtx

public Properties getCtx()

Overrides:

getCtx in class AbstractXLSXExporter

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

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

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

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

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

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

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