Cannot import excel files (Subscripted assignment dimension mismatch. ERROR)
古いコメントを表示
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 件のコメント
Arturo Moncada-Torres
2011 年 6 月 24 日
Could you please reformat your question with code format and include the code you are using?
Darren Quinn
2011 年 6 月 24 日
回答 (2 件)
Walter Roberson
2011 年 6 月 24 日
Try
which -all class
to determine whether you have accidentally introduced your own routine named "class"
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!