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
15 ビュー (過去 30 日間)
古いコメントを表示
(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 ![Capture.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/223483/Capture.png)
![Capture.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/223483/Capture.png)
0 件のコメント
回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!