Use Excel columns as X Y cell coordinates to look up Z values from matrix

Question

Peter Dorofy 2015-10-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/249582-use-excel-columns-as-x-y-cell-coordinates-to-look-up-z-values-from-matrix

回答： TastyPastry 2015-10-19

在 MATLAB Online 中打开

Hello,

I have imported an excel spreadsheet where column A are X coordinates and column B are Y coordinates

example:

Column A: 2,4,6,8, ... X

Column B: 1,3,4,7, ... Y

I have a large 2000x1000 matrix where each cell has some Z value. I need to be able to extract the Z values from the matrix using the X Y coordinates imported from Excel. Ultimately I will be exporting a third column C which contains those Z values back to excel. Below is what I have, but not sure where to go from here:

    X = xlsread('data.xlsx','A1:A100');
    Y = xlsread('data.xlsx','B1:B100');

I need to lookup and store the Z values of those 100 data points from the 2000x1000 matrix. It sounds like it should be simple, but somehow I am missing something. Any suggestions?

Thanks,

-Peter