Vtiful\Kernel\Excel::autoFilter

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

Vtiful\Kernel\Excel::autoFilterVtiful\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();
?>