Description

class Axlsx::AutoFilter

This class represents an auto filter range in a worksheet

creates a new Autofilter object

Parameters:

  • worksheet (Worksheet)

Raises:

  • (ArgumentError)

Adds a filter column. This is the recommended way to create and manage filter columns for your autofilter. In addition to the require id and type parameters, options will be passed to the filter column during instantiation.

Parameters:

  • col_id (String)

    Zero-based index indicating the AutoFilter column to which this filter information applies.

  • filter_type (Symbol)

    A symbol representing one of the supported filter types.

  • options (Hash) (defaults to: {})

    a hash of options to pass into the generated filter

actually performs the filtering of rows who's cells do not match the filter.

A collection of filterColumns for this auto_filter

the formula for the defined name required for this auto filter This prepends the worksheet name to the absolute cell reference e.g. A1:B2 -> 'Sheet1'!$A$1:$B$2

The range the autofilter should be applied to. This should be a string like 'A1:B8'

serialize the object

Returns the value of attribute worksheet

AutoFilter is referenced in 0 repositories