Matlab writes junk #N/D in Excel file

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 ?

[dpb]

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]

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

Answer 1

[OCDER]

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

[dpb]

"specify the exact excel range to write to, or don't specify it at all."

There's one alternative that is useful as well which is to specify the target cell for the upper LH corner of the array to be written...useful if don't want to overwrite a title row, for example as in Answer_329295

[farzad]

Thank you so much, since it is a data acquisition ,I don't know in advance , due to some calculations in the middle, how many points I will have, not I tried with not specifying, just I forgot, what does that 1 mean after Xsig ? Is there a complete documentation guide to deal with Excel and text files in MATLAB ?

[OCDER]

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

[farzad]

Thanks a lot