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

Unable to save NaN values when exporting from datatable

Thread ID:





29971 Jun 8,2005 11:24 AM UTC Jun 21,2005 02:05 PM UTC WinForms 2
Tags: XlsIO
Rishi Tandon
Asked On June 8, 2005 11:24 AM UTC

While exporting data from a datable into a worksheet the NaN values are copied as "2.69653970229347E+308". Is there a way to show them as "#Value"?

Rishi Tandon
Replied On June 14, 2005 02:30 PM UTC

please can someone respond to this issue.

Administrator [Syncfusion]
Replied On June 21, 2005 02:05 PM UTC

Hi Rishi, Currently there is no way to replace the values in an imported datatable. The alternative approach would be to loop through the data in the datatable and replace the NaN values , then export the data into an excel worksheet manually. Please let me know if you have any questions. Thanks, Stephen. >please can someone respond to this issue.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the 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