(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::autoFilter — Vtiful\Kernel\Excel autoFilter
$scope
)Add autofilter to a worksheet.
scopeCell start and end coordinate string.
Vtiful\Kernel\Excel instance
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();
?>