Extract data from excel using heading

Question

A T 2014-6-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133375-extract-data-from-excel-using-heading

评论： A T 2014-6-11

I have my data in an excel file. I want matlab to extract data and make a matrix from 9 places that have the same heading and the same length. The data is all located in the same column in the excel file. The locations vary between different excel files, so I want to use the heading to find data in the file not the location.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Sanchez 2014-6-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133375-extract-data-from-excel-using-heading#answer_140051

在 MATLAB Online 中打开

[data headings] = xlsread('your_excel.xls');
headings = headings(1,:);% first row of headings, in case you have some others.
head_wanted = 'your_desire_heading'; % heading of your desired column
col_desired = getnameidx(headings, head_wanted); % position of your wanted column
your_wanted_data = data(:,col_desired);

3 个评论
显示 1更早的评论隐藏 1更早的评论

David Sanchez 2014-6-9

在 MATLAB Online 中打开

This could be valid for you then:

[data headings] = xlsread('your_ecel.xls');
heading_pos =[];
for k=1:numel(headings)
    if strcmp(headings{k},'Data')
        heading_pos = [heading_pos; k];
    end
end
your_array = zeros(3,numel(heading_pos));
% valid for a long column with several Data headings/values
for k2=1:(numel(heading_pos)-1)
    your_array(:,k2) = data(heading_pos(k2):(heading_pos(k2+1)-2));
end
your_array(:,end) = data(heading_pos(end):end);