Query on spreadsheetimport options

21 vues (au cours des 30 derniers jours)
Amit Vaidya
Amit Vaidya le 31 Oct 2019
Réponse apportée : Sai Sri Pathuri le 6 Nov 2019
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

Connectez-vous pour répondre à cette question.

Réponses (1)

Sai Sri Pathuri
Sai Sri Pathuri le 6 Nov 2019
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

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Produits


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by