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. Image for the cookie policy date
close icon

Excel Export Template Column

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.


3 Replies 1 reply marked as answer

NS Nithya Sivaprakasam Syncfusion Team October 11, 2022 10:14 AM

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.


Marked as answer

HI Hiral October 13, 2022 07:06 AM

excellent 

thank you so much for this. 




VB Vinitha Balasubramanian Syncfusion Team October 14, 2022 02:22 AM

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


Loader.
Live Chat Icon For mobile
Up arrow icon