MATLAB Answers

Can readtable read variable opt in a loop?

7 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
Yes.
'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files
  3 Comments

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