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. Image for the cookie policy date

Unable to save NaN values when exporting from datatable

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"?

2 Replies

RT Rishi Tandon June 14, 2005 02:30 PM UTC

please can someone respond to this issue.

AD Administrator Syncfusion Team 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.

Live Chat Icon For mobile
Up arrow icon