data excel in matlab
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
joni nababan
le 20 Fév 2020
Modifié(e) : Walter Roberson
le 4 Mar 2020
excuse me ,
i have a problem in plot a data from excel to matlab
i have this code:
[filename,path] = uigetfile('.xlsx')
dataExcel = xlsread(fullfile(path,filename))
inflow = dataExcel(1:size(dataExcel,1)-107,4)
can anybody explain the code?
4 commentaires
Alex Mcaulley
le 20 Fév 2020
This is the very basics of Matlab: indexing. Take a look to matrix indexing and I recommend you to do the Matlab tutorial Matlab tutorial
Réponse acceptée
Jakob B. Nielsen
le 20 Fév 2020
Modifié(e) : Jakob B. Nielsen
le 20 Fév 2020
You have an array dataExcel which has size(dataExcel,1) rows, and size(dataExcel,2) columns. The rows would correspond exactly to the "numbers" in excel, so row 1, 2, 3 etc. whereas the columns would correspond to the "letters" in excel, column A, B and C. (Although note they are still numbered 1, 2, 3 etc in matlab, so column A in excel would be column 1 in matlab).
So the snip of code
inflow = dataExcel(1:size(dataExcel,1)-107,4);
seeks to extract the values from row 1 to row number "size(dataExcel,1)-107", so all rows except the last 107 rows. The column index 4 then refers to... well, column 4, which would be column D in your original excel file.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!