Can readtable read variable opt in a loop?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
chlor thanks
am 31 Mär. 2020
Kommentiert: chlor thanks
am 7 Apr. 2020
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 31 Mär. 2020
Yes.
'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files
3 Kommentare
Walter Roberson
am 31 Mär. 2020
Yes xlsm too.
Sheetname="1"; Col="BH" ;
readtable('YourFile.xlsm','sheet',Sheetname,'range',Col)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!