problem with xlswrite while obeying excel limits

4 次查看（过去 30 天）
Jessica jones
Jessica jones 2012-7-13
编辑： Oleg Komarov 2015-12-9
I know that there are a lot of posts on this subject but I have searched them extensively and still can't figure out why I am getting this error.
[statusD,msginfoD] = xlswrite([NewName '.xls'],DataForExport,2);
the variable DataForExport is a cell array that contains 60001 rows and 12 columns, every cell contains ether a numeric value or a string and none of the strings are longer than the limited 991 charaters (actually the longest is 50). Yet I still get the error;
message: 'Error: Object returned error code: 0x800A03EC'
identifier: 'MATLAB:COM:E2148140012'
I don't get the error if I write only the first 6 columns of data but the second 6 columns of data can not be written serially and the error is thrown again.
Any Ideas?
  1 个评论
Nirmal
Nirmal 2012-7-13
编辑：Nirmal 2012-7-13
What is the maximum length of the sum of the first 6 columns of the data?

请先登录，再进行评论。

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

回答（1 个）

Oleg Komarov
Oleg Komarov 2015-12-9
编辑：Oleg Komarov 2015-12-9
I had the following error:
message: ''
identifier: 'MATLAB:COM:E2148140012'
and it boiled down to having a column with incorrect excel formulas in my cell array, like:
'=HYPERLINK("file:///myfolder/"& filename &".pdf")'
where it should have been
'=HYPERLINK("file:///myfolder/filename.pdf")'
The erroneous formula generates an "Invalid Name Error" if pasted to excel.

类别

在 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