Exportable setting in GridColumnSettings

[VISHAAL]

Doesn't look like Exportable is available in GridColumnSettings. I'm using the LoadSettings feature on a Grid and I want to set some columns to not be exported to Excel. Exportable is a setting when using the column binding but I don't see it in the GridColumnSettings class.

[Yanislav]

Hello Vishaal,

The Exportable property that is used to specify should a column be included in the exported files comes with the R1 2021 release:
https://www.telerik.com/support/whats-new/kendo-ui/release-history/kendo-ui-r1-2021

If the application is using an older version of the Telerik UI, you should either update the version of the product or try to implement some custom functionality that prevents the column from being included in the exported file. My recommendation is to update the version of the product. For more information, please review the following article:
https://docs.telerik.com/aspnet-mvc/installation-mvc/upgrading/upgrade

However, if you decide to continue with custom implementation and not upgrade the version of Telerik UI, I recommend you review the following discussion from our forum. It discusses such an issue and might be useful to you.
https://www.telerik.com/forums/export-to-grid-hide-columns

Regards,
Yanislav
Progress Telerik

[VISHAAL]

I am working with the latest version.

This is the feature I'm using:
https://demos.telerik.com/aspnet-mvc/grid/columnsettings

There isn't a setting for exportable in Kendo.Mvc.UI.Kendo.Mvc.UI.

[Yanislav]

Hello, Vishaal

Thank you for your clarification.

Currently, such a property is not available, but it makes sense to have such an option for configuring the Grids' columns, so I have also logged a feature request on your behalf. Here is the link to the Feedback Portal item: 

https://feedback.telerik.com/aspnet-mvc/1568717-add-exportable-property-in-gridcolumnsettings

I have added a vote to the feature request on your behalf, since the votes are an indicator we use when planning feature requests for subsequent releases. The more votes a feature request gets, the higher its chances of getting approved for implementation. You can follow the linked item, to receive email notifications about status changes.

As a temporary workaround, I can recommend you modify the column options when the page is loaded (on document.ready).

Here is an example:

<script>
    $(document).ready(function () {
        var grid = $("#grid").data("kendoGrid");
        grid.columns[0].exportable = false;
    })
</script>

I hope this helps.