Home/ Manual/ xlswriter / xlsx-kernel/ Vtiful\Kernel\Excel::autoFilter

Vtiful\Kernel\Excel::autoFilter

PHP function Edit on GitHub ✎

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel autoFilter

Description

Vtiful\Kernel\Excel::autoFilter(string $scope)

Add autofilter to a worksheet.

Parameters

scope: Cell start and end coordinate string.

Return Values

Vtiful\Kernel\Excel instance

Examples

example

php

<?php
$config = [
    'path' => './tests'
];

$fileObject  = new \Vtiful\Kernel\Excel($config);

$file = $fileObject->fileName('test.xlsx')
        ->header(['name', 'age'])
        ->data($data)
        ->autoFilter('A1:B11')  // auto filter
        ->output();
?>

Source: reference/xlswriter/xlsx-kernel/auto-filter.xml · from the official PHP manual (php/doc-en)