Find and read a value in an excel spreadsheet

2 次查看（过去 30 天）

Nathan Kennedy 2017-9-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/355253-find-and-read-a-value-in-an-excel-spreadsheet

回答： KL 2017-9-5

Hi,

If I create two arrays in MATLAB that represent and store the column name and row names of a table, I want to then find the matching value in an excel spread sheet corresponding to the column name and row name elements

Possible?

Thanks, N Kennedy

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

请先登录，再进行评论。

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

回答（1 个）

KL 2017-9-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/355253-find-and-read-a-value-in-an-excel-spreadsheet#answer_280325

在 MATLAB Online 中打开

Something like this?

filename = 'myExample.xlsx';
sheet = 1;
columnNames = {'A','B','C'};
rowNames = {'1','2','3'};
xlRange = [columnNames{1} rowNames{1}];
yourData = xlsread(filename,sheet,xlRange);