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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Platform: Windows Phone |
Control: SfDataGrid |
Published Date: January 20, 2016 |
Last Revised Date: January 20, 2016

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

 

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon 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.Close Icon