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?
4 个评论
Alex Mcaulley
2020-2-20
This code takes a part of one column of data from an excel file. What is actually your issue?
joni nababan
2020-2-20
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
joni nababan
2020-2-20
采纳的回答
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
