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

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

  • 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?

  • 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels