Links
Comment on page

Automatic filtering

Function Prototype

autoFilter(string $range): self

string $range

Filter/Filter Data Range

Example

$config = ['path' => './tests'];
$excel = new \Vtiful\Kernel\Excel($config);
$filePath = $excel->fileName("tutorial.xlsx")
->header(['name', 'age'])
->data([
['one', 10],
['two', 20],
['three', 30],
])
->autoFilter("A1:B3") // Add Filter/Filter
->output();