Query on spreadsheetimport options
2 views (last 30 days)
Show older comments
In Spreadsheetimportoptions (in script not gui). How to assign opts.variablenames from excel row in script.
0 Comments
Answers (1)
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
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!