Export Excel exceeds maxJson limit

[John]

Hello,

I have a grid which displays fine, but when trying to export to excel it exceeds the maxJson limit.  Why can the grid work, but not the export to excel?  Pageable and PageSize(100) on the grid so I'm guessing that the grid brings back data in chunks, but when it tries to export to excel and AllPages(true) that is where the problem is?

Thanks,

John

[Kostadin]

Hello John,

A possible solution is to increase the maxJsonLength in your web.config file or use server exporting. You can check out the following how to article which elaborates more on server exporting.

Regards,
Kostadin
Telerik by Progress

[John]

Hi Kostadin,

I tried various things like the web.config file but no luck. However,

was able to resolve the issue by overriding the Json method as shown below: 

protected override JsonResult Json(object data, string contentType, System.Text.Encoding contentEncoding, JsonRequestBehavior behavior)
{
return new JsonResult()
{
Data = data,
ContentType = contentType,
ContentEncoding = contentEncoding,
JsonRequestBehavior = behavior,
MaxJsonLength = Int32.MaxValue
};
}

 

[Ricardo]

Excelent. Works good