ajaxmanager and export function

[Morten]

I'd like to ajaxify a button (btnExportTasks) that uses Aspose.Cells to export some data. When set to the code below nothing happens.

What should my AjaxSettings look like?

<telerik:RadAjaxManager runat="server" ID="ram">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="btnExportTasks">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="btnExportTasks" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>

btnExportTasks code behind handler:
...
  workbook.Save(Me.Response, "StoreItemTasks.xls", ContentDisposition.Attachment, New XlsSaveOptions())

  Response.End()
End Sub

[Dimo]

Hello Morten,

Actually exporting and sending a file to the browser can be done only during a regular postback. If exporting is performed through an asynchronous request, the information can not be passed through the XMLHttpObject - that is why the communication between the browser and the server fails. You should not ajaxify the button at all.

All the best,
Dimo
the Telerik team

[Tee]

Does this rule still hold true with the latest version of Telerik? I am having trouble incorporating AJAX with my Export to Excel button. Please help. Thanks.

[Maria Ilieva]

Hi,

Note that this is general MS Ajax framework limitation and it is not directly generated by our control. Exporting any data even with asp UpdatePanel is not possible. For the general export functionality it is needed to perform a regular postback instead of Ajax call. This is the current framework behaviour and as we are built on the top of MS Ajax the same is applicable for our Ajax controls.

All the best,
Maria Ilieva
the Telerik team

[Tee]

Do you know if there is any work around for this? Thank you.

[Maria Ilieva]

Hello Tee,

You can exclude the export buttons from ajaxifying as shown below:
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/ajaxified-radgrid/what-you-should-have-in-mind/export-from-ajaxified-grid

I hope this helps.

Regards,
Maria Ilieva
Telerik