Matlab writes junk #N/D in Excel file

1 次查看（过去 30 天）
farzad
farzad 2018-7-23
评论： farzad 2018-7-24
Hi All
I should write an array of 50000x2 from MATLAB to an Excel file, the problem is MATLAB doesn't leave the next rows free and writes something like : #N/D till the line 1 milion !!!
So I should delete it all, but I have so many files
could someone kindly propose a solution ?
  2 个评论
dpb
dpb 2018-7-23
Would have to see the code that seemed to cause the problem and probably have the data as well.
Are you sure the sheet(s) weren't already that way first?
farzad
farzad 2018-7-23
Matlab creates that file, so the files did not exist before even , my part of the code to make the excel file and write the array to that is :
Xsig = [t,Xavp];
xlswrite(name, Xsig, 1, 'A:B');
up, Xavp is a 50,000x1 array, which will be added to Xsig together with time, with the same length, I believe that a random big array will behave the same here

请先登录，再进行评论。

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

采纳的回答

OCDER
OCDER 2018-7-23
编辑：OCDER 2018-7-23
Either specify the exact excel range to write to, or don't specify it at all.
Xsig = rand(10, 2);
xlswrite('test.xlsx', Xsig, 1, sprintf('A1:B%d', size(Xsig, 1)));
OR
Xsig = rand(10, 2);
xlswrite('test.xlsx', Xsig, 1);
When you say write to 'A:B', Matlab has an odd behavior to fill EVERY cell in columns A and B with something. Hence, the 1 million rows of N/A's
  4 个评论
显示 2更早的评论
OCDER
OCDER 2018-7-23
xlswrite(name, Xsig, 1, 'A:B');
^ sheet number
You could try
doc xlswrite
help xlswrite
or go to: https://www.mathworks.com/help/matlab/ref/xlswrite.html

请先登录，再进行评论。

更多回答（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