com.neurosys.etl.excel.filters

Class MergedColumnAndHeaderFilter

java.lang.Object

com.neurosys.etl.excel.filters.MergedColumnAndHeaderFilter

All Implemented Interfaces:

WorksheetPredicate, org.apache.commons.collections.Predicate

public class MergedColumnAndHeaderFilter
extends Object
implements WorksheetPredicate

Filters an Excel Row that is a bunch of merged columns or the header row or is an Empty Row (Empty row is where all cells in the row are empty)
By default it assumes 0th row to be the Header and skips. One can override dropHeaderRows to change this.

Author:

Arjun Dhar

Constructor Summary

Constructors

Constructor and Description
MergedColumnAndHeaderFilter()

Method Summary

Modifier and Type	Method and Description
boolean	evaluate(Object object)
boolean	evaluate(Object object, org.apache.poi.ss.usermodel.Sheet worksheet) Return false if its a header or a merged set of columns
int	getDropHeaderRows() Usually Sheets have a header, drop dropHeaderRows from the top.
org.apache.poi.ss.usermodel.Sheet	getWorksheet() check if a Sheet has been set
boolean	isConsiderStringBlankCellsAsEmpty() When filtering if row is found to have Cells String but BLANK then also consider them to be empty. Note: A Blank is none or more SPACE characters
boolean	isDropRowsWithOnlyFirstColumn() Usually some rows maybe delimited by a Delimiter Row that can only have one value in its 0th col, drop them
void	setConsiderStringBlankCellsAsEmpty(boolean considerStringBlankCellsAsEmpty) When filtering if row is found to have Cells String but BLANK then also consider them to be empty. Note: A Blank is none or more SPACE characters
void	setDropHeaderRows(int dropHeaderRows) Usually Sheets have a header, drop dropHeaderRows from the top.
void	setDropRowsWithOnlyFirstColumn(boolean dropRowsWithOnlyFirstColumn) Usually some rows maybe delimited by a Delimiter Row that can only have one value in its 0th col, drop them
void	setWorksheet(org.apache.poi.ss.usermodel.Sheet worksheet) Deprecated.

Methods inherited from class java.lang.Object

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

Constructor Detail

MergedColumnAndHeaderFilter

public MergedColumnAndHeaderFilter()

Method Detail

evaluate

public boolean evaluate(Object object)

Specified by:

evaluate in interface org.apache.commons.collections.Predicate

evaluate

public boolean evaluate(Object object,
                        org.apache.poi.ss.usermodel.Sheet worksheet)

Return false if its a header or a merged set of columns

Specified by:

evaluate in interface WorksheetPredicate

Returns:

false to filter the row out, true to consider it.

getWorksheet

public org.apache.poi.ss.usermodel.Sheet getWorksheet()

check if a Sheet has been set

Specified by:

getWorksheet in interface WorksheetPredicate

setWorksheet

@Deprecated
public void setWorksheet(org.apache.poi.ss.usermodel.Sheet worksheet)

Deprecated.

Better to use evaluate(object, Sheet)

getDropHeaderRows

public int getDropHeaderRows()

Usually Sheets have a header, drop dropHeaderRows from the top.

Default value:

1

setDropHeaderRows

public void setDropHeaderRows(int dropHeaderRows)

Usually Sheets have a header, drop dropHeaderRows from the top.

Default value:

1

isConsiderStringBlankCellsAsEmpty

public boolean isConsiderStringBlankCellsAsEmpty()

When filtering if row is found to have Cells String but BLANK then also consider them to be empty.
Note: A Blank is none or more SPACE characters

setConsiderStringBlankCellsAsEmpty

public void setConsiderStringBlankCellsAsEmpty(boolean considerStringBlankCellsAsEmpty)

When filtering if row is found to have Cells String but BLANK then also consider them to be empty.
Note: A Blank is none or more SPACE characters

isDropRowsWithOnlyFirstColumn

public boolean isDropRowsWithOnlyFirstColumn()

Usually some rows maybe delimited by a Delimiter Row that can only have one value in its 0th col, drop them

Default value:

true

setDropRowsWithOnlyFirstColumn

public void setDropRowsWithOnlyFirstColumn(boolean dropRowsWithOnlyFirstColumn)

Usually some rows maybe delimited by a Delimiter Row that can only have one value in its 0th col, drop them

Default value:

true