Matlab writes junk #N/D in Excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
farzad
el 23 de Jul. de 2018
Comentada: farzad
el 24 de Jul. de 2018
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 comentarios
dpb
el 23 de Jul. de 2018
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?
Respuesta aceptada
OCDER
el 23 de Jul. de 2018
Editada: OCDER
el 23 de Jul. de 2018
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 comentarios
OCDER
el 23 de Jul. de 2018
xlswrite(name, Xsig, 1, 'A:B');
^ sheet number
You could try
doc xlswrite
help xlswrite
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!