Completed
Last Updated: 23 Feb 2023 07:22 by ADMIN
Release 2.30.0
Tom
Created on: 18 Aug 2020 12:12
Category: Grid
Type: Feature Request
10
Custom Format for Excel Export per column

I would like to be able to customize the default format for dates and numbers that the grid has to, for example, use the current UI culture of my app.

*** Thread created by admin on customer behalf ***

3 comments
ADMIN
Nadezhda Tacheva
Posted on: 23 Feb 2023 07:22

Hi Dean,

In UI for Blazor 2.30. we released a couple of export events that allow you to customize the exported file:

  • OnBeforeExport - you can handle that to make specific file customizations based on the built-in options. For example, set the width/format of the columns, specify which data to be exported.

  • OnAfterExport - this event provides access to the output of the exported file as a memory stream. This gives you full control to perform any desired customizations using the RadSpreadProcessing library, for example.

I hope you will find the above information useful. Take your time to revise and test the customization options and please let us know if any other questions appear.

In the meantime, we will consider documentation improvement, so these details are more easily discoverable. 

Regards,
Nadezhda Tacheva
Progress Telerik

Learn about the important changes coming in UI for Blazor 4.0 in January 2023!
Dean
Posted on: 16 Feb 2023 10:13
I'm confused - if this was completed in release 2.30.0, how do we do it?  The documentation still appears to show it's not possible?
ADMIN
Marin Bratanov
Posted on: 18 Aug 2020 12:14

A workaround option could be creating the file with your own code, you can see an example of doing that in my post from 13 Jan 2020  here.

 

Regards,
Marin Bratanov
Progress Telerik