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.

Unable to save NaN values when exporting from datatable

Thread ID:





29971 Jun 8,2005 07:24 AM Jun 21,2005 10:05 AM Windows Forms 2
Tags: XlsIO
Rishi Tandon
Asked On June 8, 2005 07:24 AM

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 10:30 AM

please can someone respond to this issue.

Administrator [Syncfusion]
Replied On June 21, 2005 10:05 AM

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.

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.