Problem loading excel file into MATLAB
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hi,
I'm facing a problem in loading Excel data into MATLAB. It says:
??? Index exceeds matrix dimensions.
Error in ==> importdata>readFromExcelFile at 720 out = subsasgn(out, [substruct('.', 'colheaders') baseSubs{i}], s(likely_row, :));
Error in ==> importdata at 152 out = readFromExcelFile(FileName, descr, out, bFlatten);
Error in ==> test at 8 worksheet = importdata (location); %Loads data from the specified location
The problem is for only certain files, while other similar files work fine. Does anyone know how to tackle this?
P.S: Excel 2010, OS: Windows 7
Thanks.
0 comentarios
Respuestas (2)
Jan
el 17 de Ag. de 2011
What is the difference between the working and not working files? While you have the possibilities to find it, we can only guess.
You can enable the debugger to find out more details:
dbstop if error
Then MATLAB stops, if the error occurs, and you can inspect the values of the local variables "baseSubs", "i", "s" and "likely_row".
Friedrich
el 17 de Ag. de 2011
Hi,
are you using the Import Wizard or importdata function together with R2009b? If so, thats a known Bug. You can use xlsread instead and it will work just fine.
Or you can contact the Technical Support which should have a patch for this.
2 comentarios
Friedrich
el 17 de Ag. de 2011
That wasn't a guess. This bug happens in R2009b only. If you want a patch contact TS.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!