Find and read a value in an excel spreadsheet
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
KL
am 5 Sep. 2017
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);
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!