Error code 0x800A03EC when using xlswrite

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.

Answer 1

[Friedrich]

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).

[Jenny]

The xlsx works. Thank you.

[Mischa Kim]

Friedrich, you got my vote on that one.

[daniel]

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]

Thanks... I was using only xlswrite('Data',D) which gave error. xlswrite('Data.xlsx',D) is perfect...