We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to export current page/selected record

How to export current page/selected record?

 

This KB showcase the example to export the current page/selected records from the Grid. In the ToolbarClick event, we have to update selected records or currentViewData into Grid model and export the Grid.

 

MVC Razor

 

 

Controller

 

Likewise for ASP.Net Grid, retrieve the Grid model from the HttpContext. Refer the following code example.

 

ASPX

 

    <ej:Grid ID="FlatGrid" runat="server" OnServerWordExporting="WordExport" OnServerPdfExporting="PDFExport" OnServerExcelExporting="ExcelExport" AllowPaging="True">

        <ToolbarSettings ShowToolbar="true" ToolbarItems="excelExport,pdfExport,wordExport"></ToolbarSettings>

        <Columns>

            <ej:Column Field="OrderID" />

            <ej:Column Field="CustomerID" />

            <ej:Column Field="EmployeeID" />

            <ej:Column Field="Freight" Format="{0:C}" />

        </Columns>

        <ClientSideEvents ToolbarClick="onToolbarClick" />

    </ej:Grid>

 

 

ASPX.cs

 

 

The following screenshot show Exported Grid and Grid with Exporting enabled.

Figure 1: CurrentViewData of Grid in Exported Excel

 

Figure 2: Exporting Grid
Article ID: Published Date: Last Revised Date: Platform: Control:
6331 02/16/2016 02/16/2016 ASP.NET MVC Grid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.