Hello,
I need to set the background color of each row.
I have a function that exports a grids rows to excel document.
I need to remove any colours on the grids rows to be no colors.
Hows this done exactly? I see from reading the forums that I somehow must use the rowformatting event.
Need to know how I would call that and loop thru the rows to clear the background color.
Thanks in advance.
2 Answers, 1 is accepted
0
Frank
Top achievements
Rank 1
Rank 1
answered on 15 Oct 2018, 04:41 PM
Appears I can do this by using the export object.
Using the GridViewSpreadExport to export to xlsx file and setting the exportformat to Telerik.WinControls.Export.SpreadExportFormat.Xlsx.
IT seemed to do what I wanted.
:)
0
Hello Frank,
The ExportVisualSettings property controls this. In addition, GridViewSpreadExport has its own CellFormatting event that can be used for styling the cells. Detailed information is available here: Export to Excel | RadGridView.
Should you have any other questions do not hesitate to ask.
Regards,
Dimitar
Progress Telerik
The ExportVisualSettings property controls this. In addition, GridViewSpreadExport has its own CellFormatting event that can be used for styling the cells. Detailed information is available here: Export to Excel | RadGridView.
Should you have any other questions do not hesitate to ask.
Regards,
Dimitar
Progress Telerik
Get quickly onboard and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.