Query on spreadsheetimport options

In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

Respuestas (1)

Sai Sri Pathuri
Sai Sri Pathuri el 6 de Nov. de 2019

0 votos

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

Productos

Versión

R2019a

Preguntada:

el 31 de Oct. de 2019

Respondida:

el 6 de Nov. de 2019

Community Treasure Hunt

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

Start Hunting!

Translated by