IWorksheet.ExportDataTable is truncating time from DateTime value

[Sandeep Uppalapati]

Hello,

I am trying to import an excel file which has DateTime values in format "7/6/16 4:07 AM".

But IWorksheet.ExportDataTable is importing only date value i.e "7/6/16".

I have tried all options and nothing worked.

[Sridhar Sukumar]

Hi CGN Dev Team, 

 

Sorry for the inconvenience. Please ignore our previous update.  

 

We are unable to reproduce the reported issue at our end. We have prepared a sample for your reference, which can be downloaded from the following link. 

 

Sample Link:  

http://www.syncfusion.com/downloads/support/directtrac/general/ze/ExportDataTable1570724284.zip 

 

Kindly try this sample and let us know whether the issue is resolved or not. If you are still facing this issue, then kindly share us the modified issue reproducing sample along with your Syncfusion working version. It would be helpful for us to provide you a prompt solution at the earliest. 

 

Please let us know if you have any concerns. 

 

Regards, 

Sridhar S 

 

[Sandeep Uppalapati]

Please find attached files for my program and sample excel file. 

Attachment: ImportExcel_84722b6d.zip

[Sridhar Sukumar]

Hi CGN Dev Team, 

 

Thank you for updating us. 

 

We are able to reproduce the issue with “ExportDataTable is truncating time from DateTime value” and this issue is already fixed in the latest version 14.2. So we request you to upgrade the latest version of essential studio which can be downloaded from the following link: 

 

https://www.syncfusion.com/forums/124709/essential-studio-2016-volume-2-release-v14-2-0-26-is-available-for-download 

 

Please let us know if you have any concerns. 

 

Regards, 

Sridhar S. 

[Sandeep Uppalapati]

Hello,

I don't have subscription to 14.2. Please provide a patch for the 12.0.43. Thanks.

[Sridhar Sukumar]

Hi CGN Dev Team,  

 

A support incident to track this issue has been created under your account. Please log on to our support website to check for further updates 

 

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents  

 

Please let me know if you have any questions. 

 

Regards, 

Sridhar S