MATLAB Answers

data excel in matlab

1 view (last 30 days)
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

Show 1 older comment
joni nababan
joni nababan on 20 Feb 2020
i dont understant how to determine the column and rows
can you explain ?
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.

  1 Comment

joni nababan
joni nababan on 20 Feb 2020
Thank you so much

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!