Can readtable read variable opt in a loop?
조회 수: 1 (최근 30일)
이전 댓글 표시
I have a lot of xlsm files to process.
Essentially I have a loop that searched for sheet name and column name that satisfies certain criteria and retrieve and store the sheet name and column, for example in a particular loop, perhaps,
SheetName = “1”; Col = “BH”;
Can I set these variable as options to readtable?
댓글 수: 0
채택된 답변
Walter Roberson
2020년 3월 31일
Yes.
'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files
댓글 수: 3
Walter Roberson
2020년 3월 31일
Yes xlsm too.
Sheetname="1"; Col="BH" ;
readtable('YourFile.xlsm','sheet',Sheetname,'range',Col)
추가 답변 (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!