Can readtable read variable opt in a loop?

2 次查看（过去 30 天）
chlor thanks
chlor thanks 2020-3-31
评论： chlor thanks 2020-4-7
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?

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-3-31
Yes.
https://www.mathworks.com/help/matlab/ref/readtable.html#d120e1047964
'sheet' and 'range' are both valid for "spreadsheet" (.xls, .xlsx) files

更多回答（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!

Translated by