Unable to save NaN values when exporting from datatable

Question

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 · Answer

please can someone respond to this issue.

Administrator · Answer

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.