GUIDE - Reading from excel sheet rows and store them

I am reading from an excel sheet , I wrote this line to get the rows of matrix m, so that I have to send it (the matrix) as input to a function. But after the loop is ended all rows are considered as one row! I have to separate them by ';' and stores all of them in an array.

   for i=1:10
    data = xlsread(filename);
    m=data(i,:);
    handles.m=m;
    guidata(hObject,handles)
    end

So this is what I tried :

a{i} = strcat(m{i},';');
handles.a=a;

I was thinking that by this way after each row a semi comma will be added. But it doesn't work. How can I do that?

Answer 1

[Walter Roberson]

No loop.

data = xlsread(filename);
handles.m = data;
guidata(hObject, handles);

[Ali Jaber]

I want to read by rows not columns

[Walter Roberson]

The above gives you an array with the same layout as you have in the spreadsheet. The things that appear across rows in the spreadsheet will appear across rows in the array.

If you need to switch the order then

handles.m = data.';

however that would be "by column" rather than "by row".