Query on spreadsheetimport options
Show older comments
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.
Answers (1)
Sai Sri Pathuri
on 6 Nov 2019
0 votes
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
Categories
Find more on Spreadsheets in Help Center and File Exchange
on 31 Oct 2019
on 6 Nov 2019
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
