excel x & y

1 次查看（过去 30 天）

Alireza Lashgary 2016-8-4

评论： Alireza Lashgary 2016-8-4

Hi there i read two columns from an excel file. first column is x and second is y. i get x from user , how can a i find y for that x?

for example user inputs 0.531 i must show 0.5103 or user inputs 0.536 i must show 0.5154

my matrix is 2x1000 ( 2 columns and 1000 rows) please help

Azzi Abdelmalek 2016-8-4

编辑：Azzi Abdelmalek 2016-8-4

If M is your matrix

M=[0.5310 0.5103;0.5320 .5080;0.5330 0.5144]
x=0.5310
idx=ismember(M(:,1),x)
y=M(idx,2)

thanks

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by