MATLAB: Error code 0x800A03EC when using xlswrite

error code 0x800a03ecxlswrite

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.

My data is met, it has 60,000 lines.

What is this error and how do I correct for it?

The data that I am using is attached.

Best Answer

Take a look at this Answer from Technical Support.

Related Solutions

MATLAB: Error code 0x800A03EC when using xlswrite

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

MATLAB: Xlswrite from cell and strcat error 0x800A03EC

Try

writetable(cell2table(BB),'fileB.xls', 'WriteVariableNames', false)

Note that this would be for the case where you want the cells to contain those literal strings, not for the case where you are trying to write macros at those locations. For that task of writing macros, what I find is https://stackoverflow.com/questions/48190180/can-matlab-write-a-macro-in-an-excel-file-via-activex

Best Answer

Related Solutions

MATLAB: Error code 0x800A03EC when using xlswrite

MATLAB: Xlswrite from cell and strcat error 0x800A03EC

Related Question