How to Export Wijmo Flexsheet by applying backgroung colour for some rows?

How to Export Wijmo Flexsheet by applying backgroung colour for some rows?

Posted by: teenu.k on 22 November 2022, 11:42 pm EST

• 

  teenu.k

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 November 2022, 11:42 pm EST

  Hi,
  
  In component.ts file I have,

  excellExport() { this.flexsheet.saveAsync(this.globals.reportmenu+“-”+this.selectedMonth); }[/b]

  I have to apply background color to some rows by checking the column values in Flexsheet.
  
  How can I export the Flexsheet by applying the background color to the rows?

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 23 November 2022, 11:09 pm EST

  Hi,

  You can use ‘FlexGridXlsxConverter’ to export the flexSheet, by changing the color of specific rows based on the row data. You’ll need to use the ‘formatItem’ method of the ‘IFlexGridXlsxOptions’ to implement this.
  
  Please refer to the following sample for it’s full implementation - https://stackblitz.com/edit/angular-glubps?file=src/app/app.component.ts

  Regards