Export to Excel does not take filters into account

Question

Hi,I have an MVC4 page with the Syncfusion Grid and some filters around the grid (ListBox). These filters work perfect when using a pager (I declared an OnBeginAction where I store all current filter values in args.data). But the default Export to Excel button is not able to do this. It can respond to a OnToolbarClickEvent. But this doesn't give me access to args.data. Is there a workaround for this?

Sarath Kumar P · Answer

Hi Bas,

Thanks for using Syncfusion products.

We would like to let you know that in toolbar click event for excel check the condition if (args._currentItemIndex == 0) then save the value in a variable and append the variable to the Excel form. In ExportToExcel action find the appended value in FormCollection fc variable.

Please refer the below code snippets for your reference.

[controller.cs]

public ActionResult ExportToExcel(PagingParams args, FormCollection fc) //find the value in fc->base->All Keys.

{

var data = OrderRepository.GetAllRecords().Take(200).ToList();

return data.GridExportToExcel<MvcApplication627.Models.Student>("GridExcel.xlsx", ExcelVersion.Excel2007, args.ExportOption);

}

[view.cshtml]

function ToolbarClick(sender, args) {

if (args._currentItemIndex == 0) {

var excel = "<input type='hidden' name='10000' id='excel'/>";

$("#GenericListGrid_exportExcel").append(excel);

}

</script>

Please refer our sample from the below link for your reference.

Link-Export.zip

Please let us know if you need further assistance.

Regards,

P.Sarathkumar.

Faizan Haider · Answer

Yes