Vtiful\Kernel\Excel::autoFilter

(PECL xlswriter >= 1.2.1)

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

説明

public 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 = $excel->fileName('test.xlsx')
        ->header(['name', 'age'])
        ->data($data)
        ->autoFilter('A1:B11')  // auto filter
        ->output();
?>

関連キーワード: 　Vtiful, Kernel, autoFilter, string, addSheet, constMemory, xlswriter, public, Add, autofilter