xlsread sheet read problem

1 view (last 30 days)
Shiyang
Shiyang on 4 Nov 2012
Commented: Anqi Li on 17 Oct 2014
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 Comment
Anqi Li
Anqi Li on 17 Oct 2014
same problem here. I'm using MATLAB R2014a on Mac. Please help me.

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!