Info
Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.
GUIDE - Reading from excel sheet rows and store them
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Walter Roberson
am 4 Apr. 2016
No loop.
data = xlsread(filename);
handles.m = data;
guidata(hObject, handles);
2 Kommentare
Walter Roberson
am 4 Apr. 2016
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".
Diese Frage ist geschlossen.
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!