MATLAB Answers

Index Exceeds Matrix Dimensions

5 views (last 30 days)
James
James on 24 Dec 2019
Commented: James on 26 Dec 2019
Hello,
Apologies in advance for posting a common error/problem but I couldn't find relevant solutions in other simliar threads.
So I'm trying out this code which I found online and it gives the above mentioned error at:
srdata=struct('data',[],'Longitude',[],'Lattitude',[],'altitude',[],'Description',[]);
[data, txt] = xlsread('sample.xlsx');
[m,n] = size(data)
srdata.data = data(:,1);
srdata.Longitude = data(:,2);
srdata.Lattitude = data(:,3);
srdata.altitude = data(:,4);
for i=1:m
srdata.Description{i,1} = txt{i,5};
end
error line points at "srdata.Description{i,1} = txt{i,5};" and says "Index Exceeds Matrix Dimensions".
I wanted to know why am I getting this and how to fix this, if possible.
P.S: sample.xlsx is something like this.
Capture.JPG
Thanks in advance!

  0 Comments

Sign in to comment.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 24 Dec 2019
T = readtable('sample.xlsx','ReadVariableNames',0);
T.Properties.VariableNames = {'data','Longitude','Lattitude','altitude','Description'};
srdata = table2struct(T);

  3 Comments

James
James on 24 Dec 2019
Thank you very much!
I was wondering whether there is another way to alter the old code without replacing it to get over the error?
Andrei Bobrov
Andrei Bobrov on 24 Dec 2019
[data, txt] = xlsread('sample.xlsx');
m = size(data,1);
srdata=struct('data',cell(m,1),'Longitude',[],'Lattitude',[],'altitude',[],'Description',[]);
for i = 1:m
srdata(i).data = data(i,1);
srdata(i).Longitude = data(i,2);
srdata(i).Lattitude = data(i,3);
srdata(i).altitude = data(i,4);
srdata(i).Description = txt{i};
end
James
James on 26 Dec 2019
Thank you so much!

Sign in to comment.

More Answers (0)

Sign in to answer this question.