How to export grid data to Excel, Word and PDF formats on external action

The Grid data export can be done externally using the “export” public method of the Grid. The export method will take three parameter such as URL to the export method, Server event name which is used in web forms and a third Boolean parameter to enable multiple grid export.

In the below, we have explained how to use the export method out of the grid to export the grid data. We have exported the grid data on button click.

The Grid initialization will be as follows.

JS

MVC

ASPX

The client side click event of the button in which we have invoked export operation is as follows.

We have used the Web API controller to perform the export operation and we can also MVC controllers or ASP.Net web methods to perform export. The Web API controller used is as follows.

The output will be as follows.

Figure 1: Grid with external button to perform export data.

Figure 2: Exported Excel file.