Declined
Last Updated: 13 Apr 2022 13:25 by ADMIN
Nicholas
Created on: 30 Mar 2022 18:34
Category: Grid
Type: Feature Request
1
Add Lambda(s) to manipulate Excel Export

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.

 

 

3 comments
ADMIN
Nadezhda Tacheva
Posted on: 13 Apr 2022 13:25

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/.

Nicholas
Posted on: 06 Apr 2022 14:27
OnAfterExport does not expose all properties like conditional formatting of background colors, etc.
ADMIN
Nadezhda Tacheva
Posted on: 06 Apr 2022 08:40

Hi Nicholas,

We've exposed a couple of events that let you customize the files exported to Excel and CSV:

  • OnBeforeExport - fires after the export was initiated (via button click or programmatically).

  • OnAfterExport - fires after the OnBeforeExport event, and before the actual file is provided to the user.

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.