how to read a column named by some header in excel by using matlab?

5 次查看（过去 30 天）
Ravikant Singh
Ravikant Singh 2014-3-5
评论： rubenocar Rui-Carrillo 2016-10-7
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.

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

采纳的回答

Chandrasekhar
Chandrasekhar 2014-3-5
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'])

更多回答（1 个）

Ravikant Singh
Ravikant Singh 2014-3-7
thnx

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by