Query on spreadsheetimport options

19 visualizzazioni (ultimi 30 giorni)
Amit Vaidya
Amit Vaidya il 31 Ott 2019
Risposto: Sai Sri Pathuri il 6 Nov 2019
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

Accedi per rispondere a questa domanda.

Risposte (1)

Sai Sri Pathuri
Sai Sri Pathuri il 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

Categorie

Scopri di più su Spreadsheets in Help Center e File Exchange

Tag

Prodotti


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by