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
조회 수: 12 (최근 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
댓글 수: 0
답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!