array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'en', ), 'this' => array ( 0 => 'vtiful-kernel-excel.autoFilter.php', 1 => 'Vtiful\\Kernel\\Excel::autoFilter', ), 'up' => array ( 0 => 'class.vtiful-kernel-excel.php', 1 => 'Vtiful\\Kernel\\Excel', ), 'prev' => array ( 0 => 'vtiful-kernel-excel.addSheet.php', 1 => 'Vtiful\\Kernel\\Excel::addSheet', ), 'next' => array ( 0 => 'vtiful-kernel-excel.constMemory.php', 1 => 'Vtiful\\Kernel\\Excel::constMemory', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/xlswriter/xlsx-kernel/auto-filter.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(PECL xlswriter >= 1.2.1)
Vtiful\Kernel\Excel::autoFilter — Vtiful\Kernel\Excel autoFilter
scope
Cell 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();
?>