Query on spreadsheetimport options

21 次查看（过去 30 天）
Amit Vaidya
Amit Vaidya 2019-10-31
回答： Sai Sri Pathuri 2019-11-6
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

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

回答（1 个）

Sai Sri Pathuri
Sai Sri Pathuri 2019-11-6
You may use readcell function to read the excel sheet in the form of a cell array and assign the desired value from cell array to opts.VariableNames variable by proper indexing.
Refer the following link for readcell function documentation
https://www.mathworks.com/help/matlab/ref/readcell.html

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by