How to export a large array from workspace to an excel sheet [Ed. so that NaNs are preserved] ?

I have an array with over a 100000 rows and columns whose values are mostly NaN's and variables. Hence, when I give the command xlswrite, only a single row is getting copied, and instead of NaN's, they are printed as a b c... and so on. Does anybody know how to properly export a large array file to an excel sheet?

Answer 1

[Arif Hoq]

try this:

A=[1 2 3; NaN 3 NaN; 4 NaN 7];  % made a matrix with Nan value
B=num2cell(A)
B(isnan(A)) ={'NaN'};  % NaN as a string
writecell(B,'myfile.xlsx')

[Jaya Poornima]

Thank you very much. I tried it, and it worked perfectly fine. All the NaN's and variables were successfully exported to excel.

[Arif Hoq]

my pleasure. Please accept my answer as an "Accepted Answer"