We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to customize cell value while exporting the SfDataGrid into Excel and PDF ?

In SfDataGrid, you can customize the cell value while exporting it into Excel and PDF by using CellsExportingEventHandler with ExcelExportingOptions and PdfExportingOptions class.

The cell value is displayed in SfDataGrid like below,

Figure 1: SfDataGrid view

Excel Exporting:

The above cell value of IsClosed (GridCheckBoxColumn) column is customized while exporting to Excel like below,

C#:

 

The cell value of IsClosed column has been customized in Exported Excel Sheet like below,

 

Figure 2: Excel View

PDF Exporting:

The above cell value of IsClosed (GridCheckBoxColumn) column is customized while exporting to PDF like below,

C#:

 

The cell value of IsClosed column has been customized in Exported PDF document like below,

Figure 3: PDF View

 

Sample Links:

WPF

WinRT

WP

UWP

 

 

 
Article ID: Published Date: Last Revised Date: Platform: Control:
5541 11/02/2015 01/20/2016 WPF SfDataGrid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.