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

var options = new ExcelExportingOptions();
 
// Assign the customized cellsExportingHandler to ExcelExportingOptions
options.CellsExportingEventHandler = cellsExportingHandler;
 
 
private void cellsExportingHandler(object sender, GridCellExcelExportingEventArgs e)
{
    // Based on the column mapping name and the cell type, we can change the cell values while exporting to excel.
    if (e.CellType == ExportCellType.RecordCell && e.ColumnName == "IsClosed")
    {
        //if the cell value is True, "Y" will be displayed else "N" will be displayed.
        if (e.CellValue.Equals(true))
            e.Range.Cells[0].Value = "Y";
        else
            e.Range.Cells[0].Value = "N";
        e.Handled = true;
    }
}

var options = new PdfExportingOptions();
 
// Assign the customized cellsExportingHandler to PdfExportingOptions
options.CellsExportingEventHandler = cellsExportingEventHandler;
 
private void cellsExportingEventHandler(object sender, GridCellPdfExportingEventArgs e)
{
 
    // Based on the column mapping name and the cell type, we can change the cell values when exporting to PDF.
    if(e.CellType==ExportCellType.RecordCell&&e.ColumnName=="IsClosed")
    {
        //if the cell value is True, "Y" will be displayed else "N" will be displyed.
        if (e.CellValue.Equals("True"))
            e.CellValue= "Y";
        else
            e.CellValue = "N";               
    }
}