Problem loading excel file into MATLAB

2011 8 17
2 个回答
6 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

回答（2 个）

Jan
Jan 2011-8-17

0 个投票

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".

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Paul T John
Paul T John 2011-8-17
There is no difference between the working and non-working files except they are different in their entries.
Both kinds have their columns headers same. I think the problem is with the headers and got around it by using
numeric = xlsread(file) instead of
worksheet = importdata (filename)

请先登录，再进行评论。

Friedrich
Friedrich 2011-8-17

0 个投票

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 个评论
显示 无 隐藏 无

Paul T John
Paul T John 2011-8-17
Known bug? Probably. But it [importdata] works for some files which are of the same kind.
Friedrich
Friedrich 2011-8-17
That wasn't a guess. This bug happens in R2009b only. If you want a patch contact TS.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by