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.
Unfortunately, activation email could not send to your email. Please try again.

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.

C#

VB

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 Windows Forms GridGroupingControl
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.