Find and read a value in an excel spreadsheet

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

Answer 1

[KL]

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);