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