Cannot import excel files (Subscripted assignment dimension mismatch. ERROR)

2011 6 24
2 个回答
1 次查看（30 天）

0 个投票

I am trying to import an Excel file, and keep being returned the below error.
??? Subscripted assignment dimension mismatch.
Error in ==> xlsfinfo at 80 indexes(i) = (strfind(class(sheet), 'Worksheet') > 0);
Error in ==> finfo at 94 [status, description] = xlsfinfo(filename);
Error in ==> uiimport>gatherFilePreviewData at 284 [type, unused, loadcmd, description] = ...
Error in ==> uiimport at 197 [ctorPreviewText, ctorHeaderLines, ctorDelim] = ...
This is a test sheet with very limited data (below), any suggestions or advice would be gratefully accepted???
Cost Type 1.2 1 2.4 1 3.1 2 1.5 2 1.1 2 1.4 1 6.5 1

2 个评论
显示 无 隐藏 无

Could you please reformat your question with code format and include the code you are using?
Darren Quinn
Darren Quinn 2011-6-24
I importing the data interactively, simply right clicking and import data from the current work directory. Does this help? The error im getting is as follows:
??? Subscripted assignment dimension mismatch.
Error in ==> xlsfinfo at 80 indexes(i) = (strfind(class(sheet), 'Worksheet') > 0);
Error in ==> finfo at 94 [status, description] = xlsfinfo(filename);
Error in ==> uiimport>gatherFilePreviewData at 284 [type, unused, loadcmd, description] = ...
Error in ==> uiimport at 197 [ctorPreviewText, ctorHeaderLines, ctorDelim] = ...

请先登录，再进行评论。

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

回答（2 个）

Walter Roberson
Walter Roberson 2011-6-24

0 个投票

Try
which -all class
to determine whether you have accidentally introduced your own routine named "class"
mashor housh
mashor housh 2011-11-2

0 个投票

you can fix this problem by changing line 80 in xlsfinfo as follows: indexes(i) = (strfind(sheet.Type, 'Worksheet') > 0);
Good luck, Mashor Housh

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by