Can readtable read variable opt in a loop?

5 views (last 30 days)
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?

Accepted Answer

Walter Roberson
Walter Roberson on 31 Mar 2020
'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by