Query on spreadsheetimport options

2 views (last 30 days)
Amit Vaidya
Amit Vaidya on 31 Oct 2019
Answered: Sai Sri Pathuri on 6 Nov 2019
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.

Sign in to answer this question.

Answers (1)

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

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!