a bug with 'xlswrite'

matlab: 64bit

office2007: 32bit

When I use xlswrite, if the number of characters in a cell exceeds 8203 (it takes me a lot of time to test this number), an error is returned: the object returns the error code: 0x800A03EC.

However, the above error will not occur on 64 bit office, and the above error will not occur if the number of characters in the cell does not exceed 8203.

[Rik]

If you have access to a 64 bit office, the workaround seems clear. This might be a limitation of the excel API. Did you file a bug report?

Answer 1

[Walter Roberson]

The limit for Excel 2007 is 8203 characters; https://forums.ivanti.com/s/article/Error-when-exporting-to-Excel-from-query-results?language=en_US