Excel Export

[Carlos Alarcon]

Hi, 

In the feature of exporting to excel, is it possible to create the excel using the "field" the instead the "header text"  as column name?

Thanks!!

[Manivel Sellamuthu]

Hi Carlos, 

Greetings from Syncfusion support. 

Yes. You can achieve your requirement by using excelHeaderQueryCellInfo event of the Grid. Please refer the below code example and sample for more information. 

<template> 

  <div id="app"> 

    <ejs-grid 

. . . 

      :excelHeaderQueryCellInfo="excelHeaderQueryCellInfo" 

    > 

       . . . 

           </ejs-grid> 

  </div> 

</template> 

<script> 

 

Vue.use(GridPlugin); 

 

export default { 

 . . . 

  methods: { 

    toolbarClick: function(args) { 

      if (args.item.text === "Excel Export") { 

        this.$refs.grid.ej2Instances.excelExport(); 

      } 

    }, 

    excelHeaderQueryCellInfo: function(args) { 

      args.cell.value = args.gridCell.column.field; 

    } 

  }, 

 . . . 

Sample: https://codesandbox.io/s/156716-excel-export-yxscj?file=/src/App.vue  

API:  https://ej2.syncfusion.com/vue/documentation/api/grid/#excelheaderquerycellinfo  

Please let us know, if you need further assistance. 

Regards, 

Manivel 

[Carlos Alarcon]

Many thanks Manivel ! :) 

[Manivel Sellamuthu]

Hi Carlos, 

Thanks for your update. 

Please let us know, if you need further assistance. 

Regards, 

Manivel