Can readtable read variable opt in a loop?

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?

Answer 1

[Walter Roberson]

Yes.

https://www.mathworks.com/help/matlab/ref/readtable.html#d120e1047964

'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files

[chlor thanks]

What about xlsm files? Also do you have an example?

[Walter Roberson]

Yes xlsm too.

Sheetname="1"; Col="BH" ;
readtable('YourFile.xlsm','sheet',Sheetname,'range',Col)

[chlor thanks]

Thank you! For col I used BH:BH