Error code 0x800A03EC when using xlswrite
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Jenny
el 7 de Feb. de 2014
Comentada: chetan sharma
el 11 de Dic. de 2015
I am trying to write out some data using xlswrite and get the error message:
Error using xlswrite (line 220) Excel returned: Error: Object returned error code: 0x800A03EC.
What is this error and how do I correct for it?
The data that I am using is attached.
0 comentarios
Respuesta aceptada
Friedrich
el 7 de Feb. de 2014
Editada: Friedrich
el 7 de Feb. de 2014
Hi,
its all about the extension. Don't use .xls extension because its inherits the row limitations of Excel 2003 which is around 65k (but you have over 90k of rows). See here for more information. So please use
xlswrite('Namsos_01_WindSpeedDirec_2001_2013.xlsx',[Hdr; num2cell(WindQCMat)]);
and it should work fine (This requieres Excel 2007 or newer).
4 comentarios
daniel
el 4 de Nov. de 2015
Well what about if I want a csv instead. It gives me the same error. I dont want to use xlsx becayse there is a significant size difference and my application. What can I do?
chetan sharma
el 11 de Dic. de 2015
Thanks... I was using only xlswrite('Data',D) which gave error. xlswrite('Data.xlsx',D) is perfect...
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!