MATLAB: How to read a column named by some header in excel by using matlab

I am having 18 to 20 columns named with different headers in n number of excel files like AOA CAS IAS ALT etc. sometimes the order of the column is changed and makes my work difficult so i want a program which will look for the column by its name like AOA and saves the data in a variable and if column is not there in the file then it will tell the user that its not available.

Best Answer

strings = {'AOA','CAS','IAS','ALT'};
[header,data] = xlsread('myxls.xls','Sheet','Range');
idx = find(strcmp(header,'AOA'));
AOA = data(:,idx);
eval(['save ' char(strings(1)) '.mat ' 'AOA'])
Related Question