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 ExchangeSpreadsheets についてさらに検索

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by