Extracting user defined data

When I run the program, it should ask for values of m, y/b ratio. I can provide y/b value as 0.15, 0.23... which the program needs to interpolate and display the answer. Is it possible to create such program?

 采纳的回答

Jon
Jon 2019-10-7

0 个投票

If you type doc readmatrix on the command line you will get all the documentation, including examples for using this function. You can also google MATLAB readmatrix.
SImilarly if you look at the documentation for interp2 it will give you examples.
If once you have done this and put together an initial code to try out your ideas and you are still stuck then please attach the code and describe the specific problems you are having.

8 个评论

column=3;
data = readmatrix('sheetdata.xlsx');
a=data(3:end,1);
v=data(3:end,column);
temp=interp1(v,a,j);
Do you have a question or a problem running your code?
If you are getting errors, that you have questions about, please copy and paste the full error message so others can see it.
Also, you can use the code button on the Matlab Answers toolbar to format you code nicely.
My problem got resolved. I used that code it worked. Pardon me for not mentioning that my issue got resolved. Thank you for your support!
Glad to hear you were able to get your program running. If this has answered your question please "accept" the answer
Jon
Jon 2019-10-8
编辑:Jon 2019-10-8
I'm glad to hear you got your program running. If this answered your question, please "accept" the answer.
I should mention that I've used interp1 and not interp2.
Oh OK. From your initial problem description I thought you were interpolating over the rows and columns of the table thus interp2. I can understand if you are selecting just one column from the table and are interpolating over the rows of that column it makes sense to use interp1

请先登录,再进行评论。

更多回答(1 个)

Jon
Jon 2019-10-7

0 个投票

You can use readmatrix to get the data out of the spreadsheet.
You can use interp2 to do the interpolation.

1 个评论

May I get a sample code on how it looks? It would clarify many of my doubts. Thank you!

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 MATLAB 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by