Extract data from excel using heading
6 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
David Sanchez
2014-6-9
[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 个评论
David Sanchez
2014-6-9
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);
you will end up with a 2D matrix holding your vector in each column
更多回答(1 个)
Sean de Wolski
2014-6-9
Use a table, that way you can index by variable name.
Attach an Excel sheet with specific instructions if you'd like a minimal working example.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!