ASP.Net AJAX – Export to Excel/Word

Tags:

Ajax

If you are using Update Panel and try to Export gridview contents to EXCEL or Word, your asp.net page will throw the following error. ”Sys.WebForms.PageRequestManagerParserErrorException”

Its because AJAX & Response.write don’t go together.  By calling Response.Write() directly you are bypassing the normal rendering mechanism of ASP.NET controls. The bits you write are going straight out to the client without further processing (well, mostly…). This means that UpdatePanel can’t encode the data in its special format.

There are couple of ways to solve this problem…

1. Place the Export Button outside of Update Panel.

2. By Pass the Export Button using <Triggers>

 </ContentTemplate>
        <Triggers>
            <asp:PostBackTrigger ControlID=”cmdExport” />
        </Triggers>

</asp:UpdatePanel>
if your Export button is part of UserControl then specify usercontrolid:buttonid

 </ContentTemplate>
        <Triggers>
            <asp:PostBackTrigger ControlID=”uscSelCtl:cmdExport” />
        </Triggers>
    </asp:UpdatePanel>

Resources:

http://pohee.com/general/sys-webforms-pagerequestmanagerparsererrorexception-in-ms-ajax/

http://gchandra.wordpress.com/2008/01/08/ajax-export-to-excel-word-syswebformspagerequestmanagerparsererrorexception/

5 Responses

  1. Wow, everyone here is just copying the same non-sense solution that someone else gave. Is there no creativity or intelligence around here? So frustrating seeing the same canned answer “word for word” in every solution page.

Leave a Reply

Your email address will not be published. Required fields are marked *