Excel Export Template Column

[Hiral]

Hello,

As we are trying to Excel export with template column for EJ2 Grid but we did not found any documentation for that. Can we do that for ASP.net core ?

How can we achieve this functionality for Excel Export EJ2 Data Grid asp.net core

Here is my column.

<e-grid-column field="FirstName" headerText="Emp Name" template="${FirstName} ${LastName}"></e-grid-column>

Thanks.

[Nithya Sivaprakasam]

Hi Hiral,

Greetings from Syncfusion support.

Query:” Excel Export Template Column”

By checking your query, we analyzed that you want to export the template column. Please check the below sample code for reference.

Code:

Index.cshtml

  

 <e-grid-column headerText="Name" template="#template" width="120"></e-grid-column>

 

……………..

 

<script id="template" type="text/x-template">

        <div>

        ${FirstName} ${LastName}

      </div>

      </script>

 

function exportQueryCellInfo(args) {

  if (args.column.headerText === 'Name') {

    args.value = args.data.FirstName + ' ' + args.data.LastName;

  }

}

We have updated how excel exports the template column in the demos. Kindly refer to the attached demo link for further information.

Demo Link: https://ej2.syncfusion.com/aspnetcore/Grid/DefaultExporting#/fluent

Please get back to us if you need further assistance on this.

Regards,

Nithya Sivaprakasam.

[Hiral]

excellent 

thank you so much for this. 

[Vinitha Balasubramanian]

Hi Hiral,

Thanks for your update.

We are happy to hear that issue has been resolved.

Please get back to us if you need further assistance.

Regards,

Vinitha Balasubramanian