xlsread sheet read problem
조회 수: 2 (최근 30일)
이전 댓글 표시
Hi!
I was trying to use xlsread to import excel files with multiple sheet. My aim is read data from each sheet, concate them and make graphs from there. The program read in 1st and 2nd sheet well but on the 3rd sheet, it gives this error:
"Error using xlsread (line 245) XLSREAD unable to read sheet 'SortedData(3)'. File contains unexpected record length. Try saving as Excel 98."
Even though the Excel file is already saved as the 97-04 format and even when all the sheets are identical (when I duplicated the first sheet and deleted the rest).
Anyone has any idea what the problem is? Is it possible that the dataset is too big for matlab to handle? (I have about two thousand items on each sheet. But this doesn't seem to be right because even if I try to run the code only on the 3rd or 4th sheet, matlab can't seem to read in the sheet properly).
Any help/suggestions much appreciated! (version: R2012a (7.14.0))
댓글 수: 1
답변 (0개)
참고 항목
카테고리
Help Center 및 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!