how to use find function to read data from excel sheet??

Question

Rohit Bhoi 2016-2-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268827-how-to-use-find-function-to-read-data-from-excel-sheet

评论： Star Strider 2016-2-18

I havee excel sheet first row is temperature while second row is elongation if user give any value of temperature then I have to find respective elongation value. then how to find that value in first row and pick up value in next cell. for e.g if user giving value 30 which is present in A8 cell then I want the value from B8.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-2-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268827-how-to-use-find-function-to-read-data-from-excel-sheet#answer_210324

First, use the xlsread function to read the file into your workspace.

Unless you absolutely must use the find function, and if your ‘temperature’ data are monotonically increasing, I would use the interp1 function instead. It’s easier, and will give more accurate results if a temperature is not exactly one in your table.

2 个评论
显示无隐藏无

Rohit Bhoi 2016-2-18

But how to acess next cell

Star Strider 2016-2-18

Read everything into your MATLAB workspace with xlsread. It should appear as a (Nx2) matrix (as you’ve described it), so using either find, or preferably interp1, with it would be straightforward after that.

请先登录，再进行评论。