Error code 0x800A03EC when using xlswrite

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更早的评论隐藏 2更早的评论

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 2015-12-11

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

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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