Export to Excel but keeping styles

Question

hello,is it possible to export grid data to excel with the specified styles (cell colors)?https://stackblitz.com/edit/angular-ninkrn-utohw7?file=default.component.tsthanksregardsviktor

Venkatesh Ayothi Raman · Answer

Hi Viktor, 

Thanks for using Syncfusion products. 

Query: is it possible to export grid data to excel with the specified styles (cell colors)? 

yes, it is possible to export grid data to excel with specified styles. To achieve your requirement, we have used excelQueryCellInfo event of the grid. In the function, we have passed the font color and background color of the cells to excel cells using style property. Please refer to the below sample and documentation for your reference. 

Code Example: 

[.ts] 




... 
excelQueryCellInfo(args: any){ 
       
      if (args.column.field === 'LastName') { 
        args.style={fontColor: "#fff", backColor: "#03a9f4"} 
        } 
    } 
... 

Sample: https://stackblitz.com/edit/angular-ninkrn-yesi1z?file=default.component.ts  

Documentation: https://ej2.syncfusion.com/documentation/grid/api-excelStyle.html?lang=typescript#properties 
                              https://ej2.syncfusion.com/documentation/grid/api-grid.html?lang=typescript#excelquerycellinfo  

Please get back to us for further assistance. 

Regards,  
Venkatesh Ayothiraman.

Viktor · Answer

perfect!!thanks!regardsviktor

Venkatesh Ayothi Raman · Answer

Hi Viktor, 
 
Thanks for the feedback. 
 
We are very happy to hear that your requirement is achieved. 
 
Regards,Venkatesh Ayothiraman.