MATLAB Answers

Query on spreadsheetimport options

5 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.

  0 Comments

Sign in to comment.

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

  0 Comments

Sign in to comment.

Sign in to answer this question.

Products


Release

R2019a