How to import and use specific columns and rows from excel, based on column titles (and some row value ranges) that can vary from file to file

Question

Nasir 2019-6-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465917-how-to-import-and-use-specific-columns-and-rows-from-excel-based-on-column-titles-and-some-row-val

评论： Nasir 2019-6-6

(looking at the attached example excel file ) i want to e able to select a specific column in this case lets say column B , but if another file is used where B is still a title but not in the same location it will still be able to improt the B column automatically. then i want to be able to do calculations in column B based on row values (if a value in column A is a certain value it will only do calculations in those rows); for example if in column A a value has 22 in the B column the same rows will be used for calculations or at least displayed in order to do the calculations . the purpose is to make this code compatible and adaptable with other excell files

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-6-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465917-how-to-import-and-use-specific-columns-and-rows-from-excel-based-on-column-titles-and-some-row-val#answer_378180

在 MATLAB Online 中打开

t1 = readtable('test1.xlsx');
mask = t1.A == 22;
B22 = t1.B(mask);

See also https://www.mathworks.com/help/matlab/ref/splitapply.html and https://www.mathworks.com/help/matlab/ref/findgroups.html

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

Nasir 2019-6-6

在 MATLAB Online 中打开

what would/can i do if instead of simple column headers i have more complicated headers such as "1234 Car Speed ", how would the be put into matlab as proper notation. As i do not have controll over what the column titles are.

t1 = readtable('test1.xlsx');
mask = t1.A == 22;
B22 = t1.B(mask);
% VS
t1 = readtable('test1.xlsx')
mask = t1.1234 Car Speed                                  == 22
B22 = t1.B(mask)