Internally it looks like you are using RadSpreadStreamProcessing for grid.ExportToExcelAsync() if you gave us an optional lamdba to manipulate IRowExporter while you are processing, it would make things a lot easier.
There were a couple other feature requests out there that you closed offering alternatives ways of doing this and we are actually just importing the stream back to RadSpreadProcessing object and then manipulating that way. Adding the Lambda would be a much more efficient way of handling this use case and probably very simple for you to implement.
Hi Nicholas,
Thank you for the clarification! The previously mentioned events indeed do not expose options for such customizations. The reason for that is there could be multiple formatting requirements and specific configurations depending on the use case, and it would be hard to cover all of them.
If you want to conditionally color only certain cells based on some condition, as you mentioned, you will need to access the actual cells of the Excel file. You may check this sample app for an example how custom export can be handled using the SpreadStreamProcessing library. It also demonstrates how to set different background color to some cells.
Having the above in mind, I have marked the request as "Declined" since we'd rather treat the scenario as custom approach. Please let us know if any further questions are raised after you revise the linked sample or if you'd need some assistance with the configuration.
Regards,
Nadezhda Tacheva
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Hi Nicholas,
We've exposed a couple of events that let you customize the files exported to Excel and CSV:
You can subscribe to these events to modify the exported file as needed. Please take a look at the options their event arguments provide and let us know if there is any desired file manipulation that you cannot achieve through these events.
Thank you in advance! I'll be looking forward to hearing from you!
Regards,
Nadezhda Tacheva
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.