Vtiful\Kernel\Excel::autoFilter

(PECL xlswriter >= 1.2.1)

Vtiful\Kernel\Excel::autoFilter — Vtiful\Kernel\Excel autoFilter

説明

public function Vtiful\Kernel\Excel::autoFilter(string $scope)

Add autofilter to a worksheet.

パラメータ

scope: Cell start and end coordinate string.

戻り値

Vtiful\Kernel\Excel instance

例

例1 example

<?php
$config = [
    'path' => './tests'
];

$fileObject  = new \Vtiful\Kernel\Excel($config);

$file = $fileObject->fileName('test.xlsx')
        ->header(['name', 'age'])
        ->data($data)
        ->autoFilter('A1:B11')  // auto filter
        ->output();
?>

関連キーワード:

Vtiful Kernel Excel autoFilter scope config fileObject addSheet constMemory xlswriter autofilter worksheet Cell start coordinate instance example path tests fileName xlsx header auto filter output