Query on spreadsheetimport options

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

Answer 1

[Sai Sri Pathuri]

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