Vtiful\Kernel\Excel::autoFilter

(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();?>