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 export the date along with the time value to Excel?

By default, the time values in the cells are not exported to Excel; only the date value is exported. To export the DateTime value of the cell, you have to set the Format property to dd/MM/yyyy h:mm:ss tt in the QueryImportExportCellInfo event.



Sample Links:

C#: Time export-C#

VB: Time export-VB

Article ID: Published Date: Last Revised Date: Platform: Control:
4787 05/06/2015 05/06/2015 WinForms GridGroupingControl
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

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

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