Can readtable read variable opt in a loop?

2 次查看（过去 30 天）

chlor thanks 2020-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/514232-can-readtable-read-variable-opt-in-a-loop

评论： 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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2020-3-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/514232-can-readtable-read-variable-opt-in-a-loop#answer_423061

Yes.

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

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2020-3-31

在 MATLAB Online 中打开

Yes xlsm too.

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

chlor thanks 2020-4-7

Thank you! For col I used BH:BH

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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