how i can import specific rows from excel and than use that row in equations MATLAB .

2 次查看(过去 30 天)
hI all;
i want to import x rowfrom excel file but those values of x which is greater than 200 not all ,second how i can use this x value in equation like y=3*x+12 in matlab.

回答(1 个)

Jon
Jon 2020-10-5
You can use the matlab command readmatrix to get the data in from Excel (type doc readmatrix on the command line for details)
This will return all the values in your spreadsheet, not just the ones where x > 200. However if you have now put these into a variable, let's call it x, you can get just those values using something like:
x = x(x>200)
to evaluate the expression you have just use
y = 3*x + 12
Just as you already have it written
  11 个评论
Engineer Batoor khan mummand
编辑:Engineer Batoor khan mummand 2020-10-7
thanks walter Roberson
;\ i have four equation which is given in last comments and four unknowns but s is given in excell range is J2:J1000.
now i want to plot(x,s)
i need matlab code
thanks u so much
Engineer Batoor khan mummand
Dear Walter Roberson :
i want to solve four equations simultaneously in order to find value of x,y,m and z by putting value of s which is given in excel file range J2:J1000 and than plot it against s.
i hope you have got my point

请先登录,再进行评论。

产品

Community Treasure Hunt

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

Start Hunting!

Translated by