data excel in matlab

1 view (last 30 days)
joni nababan
joni nababan on 20 Feb 2020
Edited: Walter Roberson on 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 Comments
Alex Mcaulley
Alex Mcaulley on 20 Feb 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
joni nababan
joni nababan on 20 Feb 2020
Thanks bro

Sign in to comment.

Accepted Answer

Jakob B. Nielsen
Jakob B. Nielsen on 20 Feb 2020
Edited: Jakob B. Nielsen on 20 Feb 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.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!