Data Export after filters are applied

[Hattan Shobokshi]

I have a kendo grid that is attached to a datasource. Users are able to apply filters on the grid and I'm wondering if there is a way to extract the data after the filters are applied?

The reason for this is that I can then send the filtered data to the server and export to csv/excel. Currently my export works, but doesn't take into account any filters. It exports all the data from the grid.

Thanks!

[Hattan Shobokshi]

I figured it out. I have to call the view function on the data source. That gives me back a javascript object with the filtered data.

var data = grid.data("kendoGrid").dataSource.view();

Thanks!

[Roberto]

Hi Hattan,
i've your same problem.
Could you help me?

[Hattan]

Hi Roberto,
Sure, have you tried calling the view function on the grids data source? That should return the data that is currently viewable in the grid.

[Jonathan]

You care to share your code on how your exporting the data grid to excel/csv? I would love to see how you are doing it.

[Vijay]

I have data in kendo grid and want export that to excell can you help me by code

[Sang]

Hi Hattan,
If you don't mind, can you share your export code?  We're looking to do the same thing.  Thanks.

[Hattan Shobokshi]

No problem. I'm currently extracting the data and sending it to an ASP.NET MVC action method that renders an excel file based on the data. The server side component is based on asp.net and uses a custom library that I built. 

I'm planning to put together a blog post to explain how I did. As soon as that's done I'll come back here and post an update.

Sorry for the delay guys, I've been super busy but I hope to have this up shortly.