Author Topic: Issue with exportExcel  (Read 2812 times)

mshapiro

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
Issue with exportExcel
« on: August 12, 2014, 11:12:28 pm »
I am having an issue with exportExcel in my ASP.NET application.  pqGrid is not sending a POST request to the controller if more than a certain number of records are displayed in the grid.  If I reduce the number of records displayed, either with filters or by changing the database query, then exportExcel works as expected.  I have determined that 2604 records (15 columns) is the maximum number that exportExcel will send.  This number increases if I reduce the number of columns in the grid.  This problem does not occur with ExportCsv.  I need help getting exportExcel to work correctly.  Thank you.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6260
    • View Profile
Re: Issue with exportExcel
« Reply #1 on: August 12, 2014, 11:30:47 pm »
you need to increase the POST request size on your server.

This post might be helpful.

http://stackoverflow.com/questions/15079397/maximum-default-post-request-size-of-iis-7-how-to-increase-64kb-65kb-limit

mshapiro

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
Re: Issue with exportExcel
« Reply #2 on: August 14, 2014, 10:05:05 pm »
Increasing maxRequestLength resolved the issue.  Thanks.