data excel in matlab

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?

[Alex Mcaulley]

This code takes a part of one column of data from an excel file. What is actually your issue?

[joni nababan]

i dont understant how to determine the column and rows

can you explain ?

[Alex Mcaulley]

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]

Thanks bro

Answer 1

[Jakob B. Nielsen]

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.

[joni nababan]

Thank you so much