xlwrite, Object returned error code: 0x800A03EC,

Hi people,

I'm using XLSWRITE to write my data. because of the number of data I have(100 set, which each has 17 numbers)I decided to write them in rows,it means 100 rows and 17 columns. By testing the small version of the programme, it returns the following error:

??? Error using ==> xlswrite at 213

Excel returned: Error: Object returned error code: 0x800A03EC.

If I store them the other way round (17 rows,100 colums) it works properly and no errors, what is the difference? it is still the same set of data, cells in excel are still the same, it is just the configuration of storing. I don't get it!!!!! would someone explain this to me and give me suggestion to fix the problem. Thank you

S:-)

Answer 1

[Fangjun Jiang]

The error code is caused by Excel. You can find lots of threads on the web. The Mathworks' website also has a few threads. It usually happens when you try to write large data. Old version Excel can not support more than 256 columns. My personal experience is that if any cell of the data exceeds 911 characters, the same error code appears.

But I was surprised the error happened for 100x17 data. Is the data all numerical? Any one of them is extremely long? Can you just have you 100x17 data in the workspace, write to a new Excel file and transpose it and try to write to another file?