data excel in matlab

2 次查看（过去 30 天）
joni nababan
joni nababan 2020-2-20
编辑： Walter Roberson 2020-3-4
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 个评论
显示 2更早的评论
Alex Mcaulley
Alex Mcaulley 2020-2-20
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jakob B. Nielsen
Jakob B. Nielsen 2020-2-20
编辑：Jakob B. Nielsen 2020-2-20
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by