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!