Error code 0x800A03EC when using xlswrite

3 次查看（过去 30 天）
Jenny
Jenny 2014-2-7
评论： chetan sharma 2015-12-11
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.

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

采纳的回答

Friedrich
Friedrich 2014-2-7
编辑：Friedrich 2014-2-7
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 个评论
显示 2更早的评论
daniel
daniel 2015-11-4
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
chetan sharma 2015-12-11
Thanks... I was using only xlswrite('Data',D) which gave error. xlswrite('Data.xlsx',D) is perfect...

请先登录，再进行评论。

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