1. Feedback
  2. Blazor
  3. 66643

Welcome to the Blazor feedback portal. We’re happy you’re here! If you have feedback on how to improve the Blazor, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

3
Votes

Need to Export the DateTime Column as DateTime object in Exported Excel File

When exporting data from the DataGrid component to an Excel spreadsheet, columns containing DateTime values are currently exported as text strings rather than as native DateTime objects. This causes issues when users attempt to perform date-based operations (e.g., sorting, filtering, or formatting) within Excel, as the data is not recognized as a valid DateTime type.

This behavior affects usability and data integrity, especially in scenarios where accurate date manipulation is essential. The expected behavior is that DateTime columns should retain their type and be exported in a format that Excel recognizes as a true DateTime object, not plain text.


Replication Sample: https://blazor.syncfusion.com/documentation/datagrid/excel-exporting


Replication Procedure:


  1. Run the excel export normal sample.
  2. Export it to the excel.
  3. Apply the filter on excel sheet.
  4. Now check the OrderDate column the concern type will be on Text instead of date time.