PivotGridV2ExcelSettingsBuilder

Methods

FileName(System.String)

Specifies the file name of the exported Excel file.

Parameters

value - System.String

The value that configures the file name.

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.FileName("PivotGridV2_Export.xlsx"))
            )

Filterable(System.Boolean)

Enables or disables the column filtering in the exported Excel file.

Parameters

value - System.Boolean

The value that toggles the column filtering option.

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.Filterable(true))
            )

Filterable()

Enables or disables the column filtering in the exported Excel file.

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.Filterable(true))
            )

ForceProxy(System.Boolean)

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

Parameters

value - System.Boolean

The value that enables or disabled the ForceProxy option.

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.ForceProxy(true).ProxyURL(Url.Action("ExportSave", "Home")))
            )

ForceProxy()

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

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.ForceProxy(true).ProxyURL(Url.Action("ExportSave", "Home")))
            )

ProxyURL(System.String)

The URL of the server side proxy that will stream the file to the end user. 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. - fileName: The file name, as requested by the caller. The proxy must return the decoded file with the "Content-Disposition" header set to 'attachment; filename="<fileName.xslx>"'.

Parameters

value - System.String

The value that configures the proxy URL.

Example

            @(Html.Kendo().PivotGridV2()
                .Name("pivotgrid")
                .Excel(excel => excel.ProxyURL(Url.Action("ExportSave", "Home")))
            )