Info

此问题已关闭。 请重新打开它进行编辑或回答。

GUIDE - Reading from excel sheet rows and store them

1 次查看（过去 30 天）
Ali Jaber
Ali Jaber 2016-4-4
关闭： 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?

此问题已关闭。

回答（1 个）

Walter Roberson
Walter Roberson 2016-4-4
No loop.
data = xlsread(filename);
handles.m = data;
guidata(hObject, handles);
  2 个评论
Walter Roberson
Walter Roberson 2016-4-4
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".

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by