\Kendo\UI\GridExcel

A PHP class representing the excel setting of Grid.

Methods

allPages

If set to true the grid will export all pages of data. By default the grid exports only the current page.

Returns

\Kendo\UI\GridExcel

Parameters

$value boolean

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->allPages(true);
?>

collapsible

Enables or disables collapsible (grouped) rows, for grids with aggregates.

Returns

\Kendo\UI\GridExcel

Parameters

$value boolean

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->collapsible(true);
?>

fileName

Specifies the file name of the exported Excel file. Must end with ".xlsx".

Returns

\Kendo\UI\GridExcel

Parameters

$value string

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->fileName('value');
?>

filterable

Enables or disables column filtering in the Excel file. When set to true the exported Excel file comes with turned on filtering for the column headers. Not to be mistaken with the grid filtering feature.

Returns

\Kendo\UI\GridExcel

Parameters

$value boolean

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->filterable(true);
?>

forceProxy

If set to true, the content will be forwarded to proxyURL even if the browser supports saving files locally.

Returns

\Kendo\UI\GridExcel

Parameters

$value boolean

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->forceProxy(true);
?>

proxyURL

The URL of the server side proxy which will stream the file to the end user.A proxy will be used when the browser isn't capable of saving files locally. Such browsers are IE version 9 and lower and Safari.The developer is responsible for implementing the server-side proxy.The proxy will receive a POST request with the following parameters in the request body: contentType: The MIME type of the file; base64: The base-64 encoded file content or fileName: The file name, as requested by the caller.. The proxy should return the decoded file with the "Content-Disposition" header set toattachment; filename="".

Returns

\Kendo\UI\GridExcel

Parameters

$value string

Example

<?php
$excel = new \Kendo\UI\GridExcel();
$excel->proxyURL('value');
?>