Vtiful\Kernel\Excel::autoFilter

(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::autoFilter — Vtiful\Kernel\Excel autoFilter

Description

public 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 #1 example


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

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

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