Package io.keikai.range.impl

Class AdvancedFilterHelper

java.lang.Object

io.keikai.range.impl.AdvancedFilterHelper

public final class AdvancedFilterHelper
extends Object

Helper class implementing the advanced filter algorithm:

1. Parse criteria range (column headers + conditions)
2. Support AND (same row) and OR (different rows) criteria
3. Support wildcard matching (*, ?)
4. Support comparison operators (>, <, >=, <=, <>)
5. Either hide non-matching rows (in-place) or copy matching rows to destination

Since:

7.0.0

Method Summary

Modifier and Type	Method	Description
static void	applyAdvancedFilter(SSheet sheet, CellRegion dataRange, CellRegion criteriaRange, CellRegion copyToRange, boolean unique, AdvancedFilterAction action)	Applies the advanced filter to the given data range.

Methods inherited from class java.lang.Object

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

Method Details

applyAdvancedFilter

public static void applyAdvancedFilter(SSheet sheet,
 CellRegion dataRange,
 CellRegion criteriaRange,
 CellRegion copyToRange,
 boolean unique,
 AdvancedFilterAction action)

Applies the advanced filter to the given data range.

Parameters:

sheet - the sheet containing the data

dataRange - the data range (including header row)

criteriaRange - the criteria range (header + condition rows)

copyToRange - destination range for COPY_TO_ANOTHER_LOCATION; may be null

unique - if true, only include unique rows

action - the filter action