xlsread sheet read problem
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!