GUIDE - Reading from excel sheet rows and store them

Question

Ali Jaber 2016-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276980-guide-reading-from-excel-sheet-rows-and-store-them

关闭： MATLAB Answer Bot 2021-8-20

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Walter Roberson 2016-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276980-guide-reading-from-excel-sheet-rows-and-store-them#answer_216305

在 MATLAB Online 中打开

No loop.

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

2 个评论
显示无隐藏无

Ali Jaber 2016-4-4

I want to read by rows not columns

Walter Roberson 2016-4-4

在 MATLAB Online 中打开

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