How to customize cell value while exporting the .NET MAUI DataGrid SfDataGrid into Excel and PDF

We can tailor a specific cell value during the export of the SfDataGrid to Excel and PDF by managing the DataGridPdfExportingController.CellExporting and DataGridExcelExportingController.CellExporting event.

Export to PDF:

The following code facilitates the customization of a cell value during the export of the SfDataGrid to PDF.

DataGridPdfExportingController pdfExport = new DataGridPdfExportingController();
pdfExport.CellExporting += PdfExport_CellExporting;

private void PdfExport_CellExporting(object? sender, DataGridCellPdfExportingEventArgs e)
{
   if (e.CellValue is string && e.CellValue == "Hannah Arakawa")
   {
       e.CellValue = "Guptill Martin";
   }
}

Export to Excel

The provided code allows for the customization of a cell value during the export of the SfDataGrid to Excel. Similar to PDF exporting.

DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
excelExport.CellExporting += ExcelExport_CellExporting;

private void ExcelExport_CellExporting(object? sender, DataGridCellExcelExportingEventArgs e)
{
   if (e.CellValue is string && e.CellValue == "Phyllis Allen")
   {
       e.CellValue = "Guptill Martin";
   }
}

View sample in GitHub

Take a moment to explore this documentation, where you can find more information about Syncfusion .NET MAUI DataGrid (SfDataGrid) with code examples. Please refer to this link to learn about the essential features of Syncfusion .NET MAUI DataGrid (SfDataGrid).

Conclusion

I hope you enjoyed learning about how to customize cell value while exporting the .NET MAUI DataGrid (SfDataGrid) into Excel and PDF.

You can refer to our .NET MAUI DataGrid’s feature tour page to learn about its other groundbreaking feature representations. You can also explore our .NET MAUI DataGrid Documentation to understand how to present and manipulate data. For current customers, you can check out our .NET MAUI components on the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to explore our .NET MAUI DataGrid and other .NET MAUI components. If you have any queries or require clarifications, please let us know in the comments below. You can also contact us through our support forums, Direct-Trac or feedback portal, or the feedback portal. We are always happy to assist you!