清空筛选条件
清空筛选条件

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

2 次查看（过去 30 天）
Jaya Poornima
Jaya Poornima 2022-3-23
评论： Arif Hoq 2022-3-24
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?

请先登录，再回答此问题。

采纳的回答

Arif Hoq
Arif Hoq 2022-3-23
编辑：Arif Hoq 2022-3-23
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')

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by